Sumifs 2003

[Trishay321]

Created something that acts like a big calculator in Excel 2007, didn't realize the formula doesn't work in 2003 now my data is gone and says #NAME?.

I have 3 criteria and I can't get the sumproduct to work correctly.

This is my sumifs:

=SUMIFS(N$10:N$523,$F$10:$F$523,"=A",$G$10:$G$523,"=1",$H$10:$H$523,"=2")

So I have 3 columns, if the first is A, the second 1, and the third 2, then I want to add the 4th column...

any easy way to do this in 2003?

[NBVC]

The equivalent would be SUMPRODUCT:

=SUMPRODUCT(N$10:N$523,($F$10:$F$523="A")*($G$10:$G$523=1)*($H$10:$H$523=2))

[tom1977]

Hi try this

Please Login or Register  to view this content.