Hi I have 15 tabs in a spreadsheet that are departments and on each department they have a list of things that they buy; but they are not in order as some departments do not buy them, Rather than put the items on, then hide the lines which is the only thing I can think of doing, I need to make a summary on another tab for head office and give each department their one, but add each item via + 60 + 80 + 90 of the amounts on each tab. is there a lookup or grid formula I can use to total them on the summary,
for example
Tab 1 Tab 2 Tab 3
Department Office is on one tab Department Shoes Department Farnb Summary of items
Ice cream 60 Ice Cream 80 ice cream 90
photos 30 photo 20 photo 20
paper 20 Paper 10 paper 21
staples 10 Staples 6 staples 22
buttons 50 Buttons 5 oranges 26
rulers 25 Rulers 2 rulers 2
tables 10 Tables 1 pens 1
microwaves 6
Its quite a lot to add each tab one the rows as there are about 30 descriptions so any help would be much appreciated x
for example
Tab 1 Tab 2 Tab 3
Department Office is on one tab Department Shoes Department Farnb Summary of items
Ice cream 60 Ice Cream 80 ice cream 90
photos 30 photo 20 photo 20
paper 20 Paper 10 paper 21
staples 10 Staples 6 staples 22
buttons 50 Buttons 5 oranges 26
rulers 25 Rulers 2 rulers 2
tables 10 Tables 1 pens 1
microwaves 6
Its quite a lot to add each tab one the rows as there are about 30 descriptions so any help would be much appreciated x