| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting blanks in a list
I have a list the includes blank values which must also be counted
Currently i am manually finding this total but i was wondering how t do it automatically. Thanks -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
counting blanks in a list
Guess what?
=COUNTBLANK(A1:J1) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "capgunkidd " wrote in message ... I have a list the includes blank values which must also be counted. Currently i am manually finding this total but i was wondering how to do it automatically. Thanks. --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
counting blanks in a list
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
counting blanks in a list
I know about the countblank function but I need it to be able to handl
any size list, as the list size varies from day to day -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Blanks | Excel Discussion (Misc queries) | |||
| counting non-blanks | New Users to Excel | |||
| Counting Blanks in a list of dates by month | Excel Worksheet Functions | |||
| Counting blanks, either 1, 2 or 3 | Excel Worksheet Functions | |||
| Counting Blanks | Excel Worksheet Functions | |||
![capgunkidd[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
