I need to get a count based on multiple criteria. I need to count if a
certain text value occurs in a column, but only if it meets a seperate date
criteria.
I have a data entry page with a vendor column and and month column. I want

I've a Issue with framing a fomula for the below Scenario in Excel:
1) I have 1 row which has week number like 40-06, 41-06, etc... in one row
which keeps repeating for all pass fail block column for 7 days.1
2) I have 1 row below which has Pass, Fail, Block which repeats for every ...

formulas entered in origin cells are copied to destination cells, to give
automatic total in dest.cell   eg. =C4/114%    -  but instead of doing this,
as it always has, excel now copies only my origin totals, to all destination
cells, and ignores the formulae.

In the PASTE SPECIAL ,what is the use of
OPERATION(Add,Sbtract,Multiply,Divide)
radio button. can anybody expliain with example.
Thanks in advance for your reply.

Have many linked spreadsheets with cell values such as:
='C:\Documents and Settings\CBH6B8\Desktop\Z-Status Report
Development\Development - 25 - Orig\[01_TEAM_STATUS.xls]TSPM Status Report'!A3
Need to define the "Transmitting" spreadsheet name (01_TEAM_STATUS.XLS in

I am looking for a formula that allows me to count the cells in a range that
have been conditionally formatted.  By this I mean only those cells that
have satisfied their respective conditions and therefore have had the
special formatting applied.

Hello! I tried using Microsoft Query to access a external data source, but
when I got the window "Choose Data source" there was nothing in the list
except for "New Data Source". I started that but after I named to data
source, I had to select a driver from a dropdown window, but ...

Can someone help me with a formula to count unique items in a range (incl
blank cells) ?
Example,
   A   B    C  

I have a statement that goes like this:
If Not Format(Sheets("Filter").Range("F99"), "000.000") =
Format(Sheets("List").Cells(FoundAddress1, 2), "000.000") And _
INDEX333 = Sheets("list").Cells(FoundAddress1, 43) Then

i have downloaded an invoice template and want the invoice number to be
sequential for each invoice.Can it be done,and how. thanks

I need to knok how do i get the last ocurrency of a char in s astring.
Example:
"i like dogs and cats" and i need to return the last position of the space,
i want to return 16 in this string, but i want to do it with some function

can i use vlookup to seek and retrive data across different sheets in excel?

I have a table with 4 statuses e.g. green, amber, red and blue.
I have a target cell which I want to be coloured according to which colour
is the predominant one.
So, if the value under 'green' is greater than the value for 'amber', 'red'

I am attempting to set up a spreadsheet whereby I can summarise the weight
load of a vehicle.  The cells will contain a variation of abbreviated texts
in the same cell e.g.
An example of column B contents is ah, zy, pd,  (in a single cell on each row)

For example
=SUM(INDIRECT(C10))
where C10 would contain
="Sheet2:"&"Sheet3!"&"A"&ROW()