hi

for detailed explantion of SUMPRODUCT visit

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

-via135

bdddd Wrote:
This works, but I'm not sure I understand why.

"Max" wrote:

Try this alternative:

=SUMPRODUCT((B3:B350=K6)*(B3:B350<=TODAY()),L3:L3 50)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"bdddd" wrote in message
...
I'm trying to find a month-to-date total for each of several years.
I used
the following formula:
=SUMIF(B3:B350,AND("="&K6,"<="&K2),L3:L350)
where B3:B350 are dates
K6 is the first of the month
K2 is Today
L3:L350 contain the amounts to total
The criteria give a "#Value!" error.

Any suggestions?





--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=512055