# Sumifs statement with one criteria looking at multiple columns to sum

I have a spreadsheet with multiple columns. In columns B, E and H, I have my payment type. In columns C, F and I are the payment amounts. I need to sum to total payments made by payment type. See attached spreadsheet as example. The formula in L5 should total \$1,100, L6 should total \$1,325, etc. How would i do this? Thanks!
Example.xlsx
###### Who is Participating?

ConsultantCommented:
Use this formula:

=SUMPRODUCT((B7:H11="Visa")*1,C7:I11)

Kevin
0

ConsultantCommented:
See attached.

Kevin
Example.xlsx
0

Senior Infrastructure Support Analyst & Systems DeveloperCommented:
Total visa = =VLOOKUP(K5,\$B\$7:\$C\$11,2)+VLOOKUP(K5,\$E\$7:\$F\$11,2)+VLOOKUP(K5,\$H\$7:\$I\$11,2)
0

Commented:
You can use SUMIF, i.e. this formula in L5 copied down

=SUMIF(B\$7:H\$11,K5,C\$7:I\$11)

regards, barry
0

Author Commented:
They all worked. Thanks for the example too Kevin!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.