Junior Member

Posts: 3

counting occurances

Hi,

I can't figure out how to count how many occurances fall between two dates. For example, how many of the dates in a column are Jan 01, 2003 and < Jan 01, 2004.

COUNTIF will count one occurance only, so I think that I have to use maybe SUMPRODUCT but am now sure how the formula would work.

Any ideas?

Thanks,

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
Totalling occurances in a column	uzusan	Excel Worksheet Functions	2	September 22nd 05 04:14 PM
Counting names in a column but counting duplicate names once	TBoe	Excel Discussion (Misc queries)	9	May 11th 05 11:24 PM
Counting Date Occurances	JerryBS	Excel Worksheet Functions	1	March 6th 05 07:29 PM
Counting multiple occurances of a specific string	BaseballFan	Excel Worksheet Functions	1	February 26th 05 08:34 PM
Counting...	Patrick G	Excel Worksheet Functions	3	February 23rd 05 10:05 PM

All times are GMT +1. The time now is 09:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us