Totaling cells in multiple worksheets
 

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.

Totaling cells in multiple worksheets
 

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.

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.

Totaling cells in multiple worksheets
 

a tiny trick:

=IF(COUNTA(Sheet1:Sheet9!A1)=0,"",COUNTA(Sheet1:Sh eet9!A1))
--
Gary''s Student - gsnu200802


"JM" wrote:

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.

Totaling cells in multiple worksheets
 

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

"Gary''s Student" wrote:

a tiny trick:

=IF(COUNTA(Sheet1:Sheet9!A1)=0,"",COUNTA(Sheet1:Sh eet9!A1))
--
Gary''s Student - gsnu200802


"JM" wrote:

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.