Totaling cells in multiple worksheets

[JM]

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.

 

[Gary''s Student]

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.

 

[JM]

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]

a tiny trick:

=IF(COUNTA(Sheet1:Sheet9!A1)=0,"",COUNTA(Sheet1:Sheet9!A1))

 

[JM]

This works. You are the best. Thank you Gary's Student