Convert SUMIFS formula from 2007 to 2003

  • Thread starter Thread starter V.P.Smruj
  • Start date Start date
V

V.P.Smruj

I have SUMIFS formula in Excel 2007

SUMIFS('Sheet'!$Q$8:$Q$12;'Sheet'!$D$8:$D$12;$D122;'Sheet'!G$8:$G$12;$D$16)

and I need to convert it to Excel 2003, but this converted formula must work
in Excel 2007 too.
Can anybody help me?
V.P.Smruj
 
Maybe condition, that converted formula must work in Excel 2007 too is not
necessary. So only how to convert it to Excel 2003.
Thanks
V.P.Smruj
 
Try...

=SUMPRODUCT(--('Sheet'!$D$8:$D$12=$D122);--('Sheet'!G$8:$G$12=$D$16);'She
et'!$Q$8:$Q$12)

....which will work in both versions of Excel.

Hope this helps!

'Sheet'!$Q$8:$Q$12;'Sheet'!$D$8:$D$12;$D122;'Sheet'!G$8:$G$12;$D$16)
 
V.P.Smruj said:
Is it possible, that my Excel 2007 doesn't know SUMPRODUCT ?
Thans
V.P.Smruj
Click to expand...

You shouldn't have a problem with it at all. Are you getting an error
value? If so, which one? If not, can you specify exactly what's
happening.

Note that in your original post your formula used a semi-colon instead
of a comma as a separator, so I used a semi-colon as a separator too.
Does your version of Excel in fact use semi-colons as a separator?
 
No, unless it is a different language version of Excel. Have you tried it?
What error message are you getting when you try to use it in Excel 2007?
You would have problems if your list separator in Windows regional settings
is set to comma instead of semi-colon, but then your SUMIFS formula wouldn't
have worked.
 
Back
Top