Solved

Sumifs statement with one criteria looking at multiple columns to sum

Posted on 2013-06-11
5
299 Views
Last Modified: 2013-06-27
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
0
Comment
Question by:brasiman
5 Comments
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 350 total points
ID: 39239599
Use this formula:

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

Kevin
0
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 39239603
See attached.

Kevin
Example.xlsx
0
 
LVL 19

Assisted Solution

by:Raheman M. Abdul
Raheman M. Abdul earned 75 total points
ID: 39239608
Total visa = =VLOOKUP(K5,$B$7:$C$11,2)+VLOOKUP(K5,$E$7:$F$11,2)+VLOOKUP(K5,$H$7:$I$11,2)
0
 
LVL 50

Assisted Solution

by:barry houdini
barry houdini earned 75 total points
ID: 39240526
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 Closing Comment

by:brasiman
ID: 39282557
They all worked. Thanks for the example too Kevin!
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question