If you want to Total the C1 to C11 values based on two criteria that is the

text â€œBâ€ in A1 to A11 and the text â€œYâ€ in B1 to B11 then use the below one:

=SUMPRODUCT((A1:A11="B")*(B1:B11="Y"),(C1:C11))

The below one will check the character B in A1:A11 and character X in B1:B11

and get the total from C1:C11

=SUMPRODUCT((A1:A11="B")*(B1:B11="X"),(C1:C11))

Like the above change the text in the above formula to get your desired data.

Instead of mentioning the value in the formula you can refer it on some

other cell and get the data by mentioning the values in the particular cells.

See the below one

=SUMPRODUCT((A1:A11=D1)*(B1:B11=E1),(C1:C11))

Now Mention the Text in D1 and E1 to get the totals.

Remember to Click Yes, if this post helps!