Sum multiple criteria

[MrMajinbuu]

HI,

I am trying to find a less clumsy way to sum values from multiple criteria. I am using sumifs currently, is there any better way to handle this ?

please see attached image cell E32

TIA

 

[bebo021999]

May be:

=SUMPRODUCT(($C$14:$C$29=$C$31)*$D$14:$D$29*E14:E29)

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[MrMajinbuu]

May be:

=SUMPRODUCT(($C$14:$C$29=$C$31)*$D$14:$D$29*E14:E29)

Thank you. It returned #Value! at first. But then i checked there is a cell with text and fixed that and the formula works perfectly

Thank you very much

 

[Peter_SSs]

Thanks for updating your account details.