Dawn S

Posts: n/a

functions

In column A are dates
In column B are values (1, 2, 3)
I want to look at A for a date greater than a specific date then match to B
for a specific number and count as 1 if they match

if A 11/30/04 and B = 1 then count as 1
If I have 5 rows that fit the criteria then the answer would be 5.

Please help with the formula, I have tried countif and nested in countif.

Thanks
Dawn

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PivotTable canned functions	doco	Excel Discussion (Misc queries)	0	January 14th 05 03:52 PM
Changing the language of built-in functions?	Gustaf Liljegren	New Users to Excel	3	December 20th 04 08:31 PM
How to call worksheet functions from Access ?	Martin Plamondon	Excel Worksheet Functions	0	November 18th 04 06:50 PM
How to load Engineering Functions into the Fx function wizard?	jsaval	Excel Worksheet Functions	1	November 11th 04 09:47 PM
Where can I see VBA code for financial functions?	eios	Excel Worksheet Functions	1	November 2nd 04 01:00 PM

All times are GMT +1. The time now is 04:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us