Sumifs for non-adjacent arrays of data

[i_excel]

Hi

I'm a long time spectator, first time poster. My question has perhaps been answered elsewhere. But I've struggled to find its solution online, so any help would be much appreciated.

I'm searching for a function that operates like sumifs() for non-adjacent arrays of data that are separated by the desired condition. Take the following for example:

A B C
3 C 2
5 C 1
6 I 9

Here, the function should return a value of 11 when the condition is "C". To further clarify my question, here is the function that I hoped would work but didn't: sumifs((A1:A3,C1:C3),B1:B3,"C"). I would prefer, if it is possible, not to have to rearrange the columns of data.

Kind regards
i_excel

 

[AhoyNC]

Try:

=SUMPRODUCT(--(B1:B3="C"),A1:A3+C1:C3)

 

[i_excel]

AhoyNC, you are as brilliant as you are modest. Thank you for your help - it works perfectly.

i_excel

 

[AhoyNC]

You're welcome. Thanks for the feedback.