| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNT Function
I need to calculate the number of cells containing data within the range
B2:B65536. Will the Count function do this? There will be blank cells present. How do you get a function to reculate itself once additional data has been added? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNT Function
=COUNTA(B:B)-COUNTA(B1)
-- Gary''s Student - gsnu200811 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNT Function
=COUNTIF(B2:B65536,"=0")
"SiH23" wrote: I need to calculate the number of cells containing data within the range B2:B65536. Will the Count function do this? There will be blank cells present. How do you get a function to reculate itself once additional data has been added? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNT Function
Hi,
Two formulas =COUNTA(B2:B65536) or =COUNTIF(B2:B65536,"<") If these help click the Yes button. -- Thanks, Shane Devenshire "SiH23" wrote: I need to calculate the number of cells containing data within the range B2:B65536. Will the Count function do this? There will be blank cells present. How do you get a function to reculate itself once additional data has been added? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count and Sum function | Excel Worksheet Functions | |||
| COUNT function | Excel Worksheet Functions | |||
| Count Function | Excel Worksheet Functions | |||
| COUNT Function | New Users to Excel | |||
| using the count function | Excel Discussion (Misc queries) | |||
Linear Mode
