| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to make a macro to clear multiple cells from multiple worksheets? | Excel Worksheet Functions | |||
| Totaling from seperate worksheets | Excel Worksheet Functions | |||
| Totaling cells from p.c. worksheets to a cell on a server workshee | Excel Discussion (Misc queries) | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
| Totaling Cells in Worksheets | Excel Worksheet Functions | |||
Linear Mode
