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
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))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Edit: Same as above
thank you
kevin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks