Convert SUMIFS formula from 2007 to 2003

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
 
V

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
 
D

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)
 
D

Domenic

V.P.Smruj said:
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?
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top