Convert SUMIFS formula from 2007 to 2003
 

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

Convert SUMIFS formula from 2007 to 2003
 

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


"V.P.Smruj" wrote:

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

Convert SUMIFS formula from 2007 to 2003
 

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)

In article ,
V.P.Smruj wrote:

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

Convert SUMIFS formula from 2007 to 2003
 

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

"Domenic" wrote:

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)

In article ,
V.P.Smruj wrote:

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

Convert SUMIFS formula from 2007 to 2003
 

In article ,
V.P.Smruj wrote:

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?

Convert SUMIFS formula from 2007 to 2003
 

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.
--
David Biddulph

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

"Domenic" wrote:

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)

In article ,
V.P.Smruj wrote:

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