Totaling cells in multiple worksheets

  • Thread starter Thread starter JM
  • Start date Start date
J

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.
 
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.
 
Ok, that works, thank you. Now, how do I keep the summation cell blank if
nothing is populated in each of the worksheets?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy cells in Excel 1
Totalling sequential worksheets 1
Identical Cells in Multiple Worksheets in one Workbook. 4
How do I find like data in multiple worksheets? 1
Sum Multiple Worksheets, same named cell 1
Spreadsheet summary automatically referrences totals of worksheets 2
When a cell is blank, add another 2

Back
Top