Totaling cells in multiple worksheets
Ok, that works, thank you. Now, how do I keep the summation cell blank if
nothing is populated in each of the worksheets?
"Gary''s Student" wrote:
If we only want to know how many cell A1's are populated:
=COUNTA(Sheet1:Sheet9!A1)
by the way, you can replace COUNTA with SUM or MIN or MAX to use these
functions across the various sheets as well.
--
Gary''s Student - gsnu200802
"JM" wrote:
I am looking to total up the same cell from multiple worksheets within a
workbook.
For instance, if I have 10 worksheets (one being the summation worksheet),
and a particular cell in 3 of those workbooks are populated with any type of
value, I want the summation worksheet to show 3. For clarity, I do not
want to add the value within the cells from multiple worksheets, just the
fact that the cell was populated with a value.
I know there is an answer out there but was not able to figure it out
myself. Thanks in advance.
|