Convert SUMIFS formula from 2007 to 2003

[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

 

[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

 

[Domenic]

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]

Is it possible, that my Excel 2007 doesn't know SUMPRODUCT ?
Thans
V.P.Smruj

 

[Domenic]

Is it possible, that my Excel 2007 doesn't know SUMPRODUCT ?
Thans
V.P.Smruj

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?

 

[David Biddulph]

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.