Try...

=SUMIF(B3:B350,"="&K6,L3:L350)-SUMIF(B3:B350,""&K2,L3:L350)

Hope this helps!

In article ,
"bdddd" wrote:

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?