=SUMPRODUCT('Washing MC Rental'!$K$4:$K$21,
--('Washing MC Rental'!$Q$4:$Q$21,=0),
--('Washing MC
Rental'!$L$4:$L$21,=--"2010-03-01"),
--('Washing MC
Rental'!$L$4:$L$21,<=--"2010-02-31"))

--

HTH

Bob

"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