SUMIFS Excel 2003

[nikialee]

Hi,

I created the following foruma in Excel 2010, but urgently need to amend it to something that will work in Excel 2003 - any advice hugely appreciated!!

=SUMIFS($AA$4:$AA$63,$AC$4:$AC$63,"Apr",$AD$4:$AD$63,"NON-VFG")

Many thanks

Nikki

 

[kevatarvind]

SUMIFS IS not availble in excel 2003 it will work only excel 2007 or higher

 

[VoG]

Try

=SUMPRODUCT(--($AC$4:$AC$63="Apr"),--($AD$4:$AD$63="NON-VFG"),$AA$4:$AA$63)

 

[nikialee]

Thanks, but no, still doesn't work...