F
Flying Ace
I am working on a spreadsheet that has multiple pages within the workbook. It
is set up so that I can keep track of various information along with data.
What I am trying to do is calculate the sum of the data that is associated
with a word/phrase from two different cells Each sheet within the workbook is
different based on the month, and so some words/phrases may not appear each
month. For instance:
January (Sheet 1) February (Sheet 2)
A1 B1 A1 B1
Name Total Name Total
Pizza 2 Hot Dog 3
Hot Dog 5 Sandwich 2
I am wanting to create a sum total for each item without having to go
through each sheet and individually select the cells for a sum. Because the
cells could change or be different. I want the totals to be calculated in
occurance to the words that they are associated with.
Is there a possible formula to do this?
is set up so that I can keep track of various information along with data.
What I am trying to do is calculate the sum of the data that is associated
with a word/phrase from two different cells Each sheet within the workbook is
different based on the month, and so some words/phrases may not appear each
month. For instance:
January (Sheet 1) February (Sheet 2)
A1 B1 A1 B1
Name Total Name Total
Pizza 2 Hot Dog 3
Hot Dog 5 Sandwich 2
I am wanting to create a sum total for each item without having to go
through each sheet and individually select the cells for a sum. Because the
cells could change or be different. I want the totals to be calculated in
occurance to the words that they are associated with.
Is there a possible formula to do this?