View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave W Dave W is offline
external usenet poster
 
Posts: 3
Default another sumifs plea

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