Software

Ask something
Question Locked

Microsoft Excel 2003

0 helpful
2 replies

by tru.notoma

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a workbook with several worksheets, within the workbook I have a master worksheet that has a compilation of all the other worksheets. What I need to happen is I want to add the total columns in the other worksheet and display the totals on the master worksheet; the issue is, not all of the items are uniform across the workbook, some share values, while some have just a few.
I tried to create a formula to scan within a certain range and only sum up the third column if the values in the first column match; below is what I have come up with that is not working for me, if anyone can solve this for me I will be your new best friend.
=IF('256th IBCT NG 0409:2-2 IBCT'!A2=A2,SUM('256th IBCT NG 0409:2-2 IBCT'!C2),"0")

2 replies

by locolobo

I may have an inelegant solution.

Do you want to sum cell C2 from several worksheets, but only where A2 on sheet(x) matches A2 on sheet(master)? That's how I read it. Here's my solution:

Find an empty cell range to populate on each subsheet. I chose D2:D6 to go with C2:C6 but you don't have to use it. I am just using the default worksheet names here; sheet1, sheet2, sheet3 using sheet1 as the master.

In cell D2 of sheet2, sheet3, etc use the formula:

=IF(A2=Sheet1!A2,C2,0)

Then assuming the sum goes in cell C2 in the master sheet the formula is:

=SUM(Sheet2:Sheet3!D2)

Obviously I only did a 3 sheet test.

I don't see an elegant way to put this into one formula on one sheet.

I'm not sure I read your problem correctly. If not explain it a little more and maybe someone can figure out something.

Good Luck

This discussion is closed to new replies.