| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert SUMIFS formula from 2007 to 2003 | Excel Discussion (Misc queries) | |||
| Excel 2007 SUMIFS formula to be use in Excel 2003 | Excel Discussion (Misc queries) | |||
| Convert/rewrite SUMIFS formula to work in Excel 97 | Excel Worksheet Functions | |||
| sumifs formula in excel 2007 | Excel Discussion (Misc queries) | |||
| Can you convert this formula to 2003 from 2007? | Excel Worksheet Functions | |||
Linear Mode
