No problem Noob, I wasn't responding to your post, just answering the
query.

Of course, if there is data for more than the one month then a
SUMPRODUCT formula would be entirely justified to sum based on multiple
criteria including dates.

However, I think your formula has an unnecessary mixture of approaches.
I'd change to

=SUMPRODUCT(--(A19:A27=DATE(2006,7,1)),--(A19:A27<=DATE(2006,7,31)),--(B19:B27="001"),C19:C27)

If your date range is always a calendar month

=SUMPRODUCT(--(TEXT(A19:A27,"mmm yy")="Jul
06"),--(B19:B27="001"),C19:C27)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=568751