shane_kidani
New Member
Look in a column and find a specified value, and then add the totals from a different column, across all sheets in the workbook.
For example, let's say I have two columns on all my sheets in my workbook. In column A, I have serial numbers; in column B, I have dollar values. Can I tell excel to look at column A for serial number 5, across all sheets, and then add up all of the dollar values?
Something like this:
Sheet 1
A B
1 5036 $400
Sheet 2
A B
31 5036 $5000
Sheet 3
I envision that this be the sheet that I would add a formula into, if this can be done.
For example, let's say I have two columns on all my sheets in my workbook. In column A, I have serial numbers; in column B, I have dollar values. Can I tell excel to look at column A for serial number 5, across all sheets, and then add up all of the dollar values?
Something like this:
Sheet 1
A B
1 5036 $400
Sheet 2
A B
31 5036 $5000
Sheet 3
I envision that this be the sheet that I would add a formula into, if this can be done.
Attachments
Last edited: