Adding values in Excel 2003

[kevincoxshall]

Hi all
I have this code working fine in excel 2007 but I need to get it working in excel 2003.

=0.02*(_xlfn.SUMIFS($D$2:$D$98,$C$2:$C$98,">="&I5,$C$2:$C$98,"<="&I4))

I have attached a test document to show what I'd like to do. It is basically adding values if the column next to it is in a certain range. counting columns in Excel 2003.xls

Hope you can help

[FDibbins]

sumifS() came out in 2007, so you cant use it in 2003. Try this instead...

=SUMPRODUCT(($B$3:$B$20)*($A$3:$A$20>=E4)*($A$3:$A$20<=E5))

[ragulduy]

Edit: Same as above

[kevincoxshall]

thank you

kevin