Solved Excel Question - How to capture numbers from tabs to master?

November 6, 2012 at 12:21:32
Specs: Windows 7
I am doing a bulk food other for several people and I have a master sheet with each person's order on a tab. I am trying to do a formula that would add specific cells from each tab to the master sheet so I have the master with the total count of each item ordered.

See More: Excel Question - How to capture numbers from tabs to master?

Report •


#1
November 6, 2012 at 13:06:15
Without knowing the layout of your spreadsheets, it's kind of hard to offer any suggestions. Something as simple as this will SUM A1 from Sheet2, 3 and 5:

=SUM(Sheet2:Sheet5!A1)

It may be as simple as that or it may be a lot more complicated. Please provide some details.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
November 6, 2012 at 13:25:53
This is what I was using but it isn't working correctly


=SUMIFS('Bobbie Poppleton Pd'!H14,'Debbie Blalock Pd'!H14, 'Janet Williams Pd'!H14, 'Jeanine Orme Pd'!H14, 'Jennifer Isom Pd'!H14,'Jody Walunas Pd'!H14,'Kim Melanson Pd'!H14,'Sandra Koester Pd'!H14,'Shannon Richards Pd'!H14,'Sharon Bramel Pd'!H14,'Sharon Koester Pd'!H14,'Shelle Wells Pd'!H14,'Suzanne Peacock Pd'!H14,'Teresa Pacelli'!H14,'Wendy Friess Pd'!H14,'Janet Little Pd'!H14,'Udell Smith Pd'!H14,'Marie Page'!H14,'Elva Miller'!H14,'Donna Brague Pd'!H14,'Genet Friess Pd'!H14,'Nina Stephenson Pd'!H14,'Sally Farb Pd'!H14,'Jennifer Waldrip Pd'!)


Report •

#3
November 6, 2012 at 14:06:45
✔ Best Answer
Are you trying to SUM H14 from all sheets? Why would you use SUMIFS?

Did you read the Help file on SUMIFS and see what it is used for?

Assuming 'Bobbie Poppleton Pd' is your first sheet and 'Jennifer Waldrip Pd' is your last, try:

=SUM('Bobbie Poppleton Pd:Jennifer Waldrip Pd'!H14)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
November 6, 2012 at 20:43:25
THANK YOU for assistance, I misread the "help" file. I thought I was suppose to use the SUMIFS instead of the SUM.....

Report •


Ask Question