Go Premium for a chance to win a PS4. Enter to Win

x
Solved

# how do i sum multiple sheets (Sumif)

Posted on 2014-02-25
Medium Priority
283 Views
I ahve the attached Workbook, and I want to create a totals sheet that will look at each Tab and sum the totals for each month.

ON PNCAPPROVES_TOTAL  I want to sum all the hours on the other two tabs based on Column B.

So in other words sum all the hours for "Lerman" from the two tabs and place in Cell C2. Do this for each value in Column B of PNCApproves_Total.

This is Sample data.
Managed-Account-Programs-PNCAPPR.xlsx
0
Question by:seamus9909

LVL 23

Accepted Solution

Ejgil Hedegaard earned 2000 total points
ID: 39887232
Formula in C2, see file.

``````=IFERROR(SUMIF(Proposal_PNCapproves!\$C\$8:\$C\$25,\$B2,INDEX(Proposal_PNCapproves!\$D\$8:\$X\$25,,MATCH(C\$1,Proposal_PNCapproves!\$D\$6:\$X\$6,0))),0)+IFERROR(SUMIF(Bonaire_PncApproves!\$C\$8:\$C\$30,\$B2,INDEX(Bonaire_PncApproves!\$D\$8:\$V\$30,,MATCH(C\$1,Bonaire_PncApproves!\$D\$6:\$V\$6,0))),0)
``````
Managed-Account-Programs-PNCAPPR.xlsx
0

LVL 19

Expert Comment

ID: 39887291
=SUMIFS(Proposal_PNCapproves!D\$9:D\$15,Proposal_PNCapproves!\$C\$9:\$C\$15,\$B2)+SUMIFS(Bonaire_PncApproves!D\$9:D\$14,Bonaire_PncApproves!\$C\$9:\$C\$14,PNCAPPROVES_TOTAL!\$B2)

Start in c2 and copy across and down
0

## Featured Post

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
###### Suggested Courses
Course of the Month12 days, 9 hours left to enroll