Sumif to multiple tabs

M

m3lly

Joined
Aug 10, 2012
Messages
2
Reaction score
0
Hi

I have a multiple tabs in a worksheet where I have similar condition just with a different first 8 digit data and numbers.

Previously this was what I did, link sumif formula to each of these tabs to derive to numbers. Is there a way to link 1 formula to all of these tabs in more time efficient way?

Tab 1 : 60111110xxxxxxxxx
Tab 2 : 60111111xxxxxxxxx

Not sure whether my question above can be understood :) Please help. Tks
 
I guess I better use an example :

Worksheet A named Sheet 1, have few lines
Cell A1 : 6011121 Cell B1 : $2
Cell A2 : 6011122 Cell B2 : $1
Cell A3 : 6011123 Cell B3 : $4

Worksheet B named Sheet 2, have few lines
Cell A1 : 6015121 Cell B1 : $5
Cell A2 : 6015122 Cell B2 : $1
Cell A3 : 6015123 Cell B3 : $3

Now, I have a summary worksheet where I have this :
6011121 $xx
6011122 $xx
6011123 $xx
6015121 $xx
6015122 $xx
6015123 $xx

Is there a way to link the formula to multiple worksheets in one go instead link the sumif to each worksheet?
 
Back
Top