Learn how to a build a cloud-first strategyRegister Now

x
Solved

SUM multiple columns for specific criteria

Posted on 2012-08-21
Medium Priority
499 Views
Please see attached file.  At the bottom I have highlighted the cells needing a formula and the question/criteria to the right of it.
Experts-Exchange-Question.xlsx
0
Question by:SPXHT

LVL 35

Assisted Solution

Norie earned 1068 total points
ID: 38316684
You could use SUMPRODUCT.

In H69:

=SUMPRODUCT(H3:H65, --(C3:C65="MFG"), --(E3:E65="F"))

in H70

=SUMPRODUCT(H3:H65, --(C3:C65="MFG"), --(E3:E65="V"))
0

LVL 24

Accepted Solution

Steve earned 532 total points
ID: 38316794
in 2007+ I would use SumifS

=SUMIFS(H:H,C:C,"MFG",E:E,"F")

See attached...
Experts-Exchange-Question.xlsx
0

Author Comment

ID: 38316811
Perfect. Thanks!
0

LVL 35

Assisted Solution

Norie earned 1068 total points
ID: 38316830
Barman

So would I but SUMPRODUCT will work in pre and post 2007 versions of Excel.
0

LVL 34

Expert Comment

ID: 38316833
With excel 2007 & later you can also use SUMIFS.

Thanks
Rob H

EDIT:

Ooops, should have refreshed before posting!!
0

Featured Post

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Suggested Courses
Course of the Month21 days, 6 hours left to enroll