If they are in an ordered set
=SUM(Anderson:Wood!C16)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Any" wrote in message
...
I am in first tab(named Texas) and I need to add same
cell c16 from each of 28 tab with different name.Is there
a way to add value of cell 16 from each 28 tabs instead
of going and adding individually.
|