Try this...

=SUMPRODUCT(--(TEXT(L4:L21,"m/yyyy")="3/2010"),--(Q4:Q21<""),--(Q4:Q21=0),K4:K21)

Add your sheet name.

--
Biff
Microsoft Excel MVP


"Dave W" wrote in message
...
I'm struggling to convert a sumifs line from 2007 to excel 2003.
The line I have working correctly in 2007 is:

=SUMIFS('Washing MC Rental'!$K$4:$K$21,'Washing MC Rental'!$Q$4:$Q$21,"=
0.00",'Washing MC Rental'!$L$4:$L$21,"28/2/2010")-SUMIFS('Washing MC
Rental'!$K$4:$K$21,'Washing MC Rental'!$Q$4:$Q$21,"= 0.00",'Washing MC
Rental'!$L$4:$L$21,"31/3/2010")
Can any one please help me to put this into 2003?
Best Regards Dave