Convert an Excel 2007 operation to Excel 2003.

[aheywood]

Hi Everybody,

Apologies if this has already been posted, but after looking through other threads relating to the same subject, I still cant seem to sort the problem out...

This is the equation:

=SUMIFS(D2:D8,A2:A8,"John",B2:B8,"DP",C2:C8,"2013")

I need to backwards convert this so that it performs the same operation but in Excel 2003. I think it has something to do with combining SUMPRODUCT and IF statement but everything i have tried has either ended with an error or has produced a 0.

I would be very greatful if someone can just translate this.

Thanks in advance to all,
Adam.

 

[RonB1111]

=SUMPRODUCT(D2:D8,--(A2:A8="John"),--(B2:B8="DP"),--(C2:C8="2013"))

 

[barry houdini]

Hello Adam,

With the "2013" criterion in SUMIFS that will match with values in C2:C8 that are either text or number.....but in SUMPRODUCT "2013" will only match with text so if Ron's formula doesn't work for you try without the quotes, i.e.

=SUMPRODUCT(D2:D8,--(A2:A8="John"),--(B2:B8="DP"),--(C2:C8=2013))