Why not take a look at the sub-total function from the Data Menu - it allows
a summary by your date(key) field and a sum, count etc for the data

--
Cheers
Nigel



"samiam1" wrote in
message ...

I am attempting to count non-blank cells in one column that have to meet
criteria from another column. I have played with the sumproduct
function but to no avail....can someone assist?

Example following:
Column A represents the Month and Year and Column B represents Costs
incurred. I want to count the number of times a Cost was incurred
during the specific Month/Year. When a cost is not incurred, the cell
remains blank.

Column A Column B
01/2004
01/2004 $25.00

01/2004
02/2004 $15.00
02/2004 $20.00
02/2004

If the formula works correctly, my results would show
01/2004 1
02/2004 2

Please let me know if you have any ideas! :)
Thanks..............


--
samiam1
------------------------------------------------------------------------
samiam1's Profile:
http://www.excelforum.com/member.php...o&userid=28741
View this thread: http://www.excelforum.com/showthread...hreadid=484338