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

Example following:
Column A represents the Month and Year and Column B represents Cost
incurred. I want to count the number of times a Cost was incurre
during the specific Month/Year. When a cost is not incurred, the cel
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.............

--
samiam
-----------------------------------------------------------------------
samiam1's Profile: http://www.excelforum.com/member.php...fo&userid=2874
View this thread: http://www.excelforum.com/showthread.php?threadid=48433