R
Ridimz
I have the following on multiple worksheets:
TAMCN NOMEN Poss DL
A0001 Name1 2 0
A0002 Name2 3 1
A0003 Name3 5 1
A0004 Name4 4 3
A0005 Name5 3 0
B0001 Name6 5 0
B0002 Name7 36 5
B0003 Name8 16 1
B0004 Name9 2 0
B0005 Name10 36 4
C0001 Name11 3 0
C0002 Name12 8 1
C0003 Name13 2 0
C0004 Name14 2 0
C0005 Name15 1 0
D0001 Name16 0 0
D0002 Name17 17 1
D0003 Name18 11 3
D0004 Name19 71 13
D0005 Name20 5 0
I would like to get a total "Poss" for all "A####", "B####", "C####", and
"D####". How would I go about this? This should allow for adding or removing
worksheets later which would be automatically included in or removed from
the total.
Thank you in advance.
TAMCN NOMEN Poss DL
A0001 Name1 2 0
A0002 Name2 3 1
A0003 Name3 5 1
A0004 Name4 4 3
A0005 Name5 3 0
B0001 Name6 5 0
B0002 Name7 36 5
B0003 Name8 16 1
B0004 Name9 2 0
B0005 Name10 36 4
C0001 Name11 3 0
C0002 Name12 8 1
C0003 Name13 2 0
C0004 Name14 2 0
C0005 Name15 1 0
D0001 Name16 0 0
D0002 Name17 17 1
D0003 Name18 11 3
D0004 Name19 71 13
D0005 Name20 5 0
I would like to get a total "Poss" for all "A####", "B####", "C####", and
"D####". How would I go about this? This should allow for adding or removing
worksheets later which would be automatically included in or removed from
the total.
Thank you in advance.