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?