I have a loaded working user form in 2007. The SumIfs function is not available in 2003. Can it be revamped to work in 2003? Is there another way? The history sheet has expected results highlighted. Here is my working code for 2007.
Any help is appreciated.
The code is run from a command button.
Please Login or Register to view this content.
SumIfs function was introduced when 2007 was released.
Yeah, I know, it's a bummer. I am looking for another way to word it or a different function that will do pretty much the same thing.Hopefully there is an old school way.
You can use either SUMPRODUCT or an array formula to replace SUMIFS in Excel 2003, so in terms of worksheet functions instead of
=SUMIFS(E:E,A:A,"x","B:B,"y","C:C,"z")
you can use
=SUMPRODUCT((A2:A100="x")*(B2:B100="y")*(C2:C100="z"),E2:E100)
or
=SUM(IF(A2:A100="x",IF(B2:B100="y",IF(C2:C100="z",E2:E100))))
confirmed with CTRL+SHIFT+ENTER
Note that I used a finite range - neither of those formulas can handle whole columns in Excel 2003
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks