sumifs "*text*" not recognised by excel 97-2003 version

[sallysunshine]

Hi

How do I write the following formula in a way that will be recognised by excel 97-2003?

=SUMIFS(H43:H82,E43:E82,"*Material*")

 

[sdsurzh]

Please Try

=SUMIF(E43:E82,"*Material*",H43:H82)

 

[SydneyGeek]

SUMIFS and COUNTIFS don't work in earlier versions of Excel. They were new in 2007.
You need to use SUMIF, as sdsurzh suggested.

Denis

 

[proficient]

Hi

How do I write the following formula in a way that will be recognised by excel 97-2003?

=SUMIFS(H43:H82,E43:E82,"*Material*")

Try this one...

=SUMPRODUCT(--(ISNUMBER(SEARCH("*MATERIAL*",$E$43:$E$82))),$H$43:$H$82)