Is the Month and year true dates or just text? If dates use

=SUMPRODUCT(--(A1:A100-DAY(A1:A100)+1=--"2004-01-01"),--(NOT(ISBLANK(B1:B100
))),B1:B100)

if it is text then use

=SUMPRODUCT(--(A1:A100="01/2004"),--(NOT(ISBLANK(B1:B100))),B1:B100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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