D
Dave W
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
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