Convert SUMIFS Function To Excel 2003

Hi, hope you can help,

I want to convert the formula below to a workable one in 2003 version. I’m aware that 2003 does not support the sumifs fiunction and cannot seem to make this work in 2003.

=SUMIFS(SAP!E:E,SAP!$A:$A,”*”&$A64&”*”,SAP!C:C,$B64)

many thanks

Conrad

Leave a Reply

Your email address will not be published. Required fields are marked *