View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
V.P.Smruj[_2_] V.P.Smruj[_2_] is offline
external usenet poster
 
Posts: 2
Default 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