SumIFs

[RJB78]

Hello. I am looking for a formula that will find specific letters in column B and sum the value located in column J of all the specific letters.

Example:
Letter Value
A 1
B 2
C 3
D 4
E 5

=SUMIFS(J1:J5,B1:B5,"A",B1:B5,"C",B1:B5,"E") This should equal '9' but excel is showing it as '0'
=SUMIFS(J1:J5,B1:B5,"B",B1:B5,"D")


Thank you

 

[Marcílio_Lobão]

RJB78, Good afternoon.

Try to use:

=SUM(SUMIFS(J1:J5,B1:B5,{"A","C","E"}))

=SUM(SUMIFS(J1:J5,B1:B5,{"B","D"}))

Please, tell us if it worked for you.

I hope it helps.

 

[RJB78]

That worked great. Thank you

 

[Marcílio_Lobão]

RJB78, Good afternoon.

Glad to have helped you.