ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Counting non-blank cells in a column, excluding hidden rows (https://www.excelbanter.com/excel-worksheet-functions/144855-counting-non-blank-cells-column-excluding-hidden-rows.html)

SisterDell

Counting non-blank cells in a column, excluding hidden rows
 
How do I do this?

Don Guillett

Counting non-blank cells in a column, excluding hidden rows
 
will the SUBTOTAL function help?

--
Don Guillett
SalesAid Software

"SisterDell" wrote in message
...
How do I do this?



SisterDell

Counting non-blank cells in a column, excluding hidden rows
 
Yes, but it adds in extra rows to subtotal every occurrence. But it did do
the trick! Thank you.

"Don Guillett" wrote:

will the SUBTOTAL function help?

--
Don Guillett
SalesAid Software

"SisterDell" wrote in message
...
How do I do this?




Don Guillett

Counting non-blank cells in a column, excluding hidden rows
 
glad to help

--
Don Guillett
SalesAid Software

"SisterDell" wrote in message
...
Yes, but it adds in extra rows to subtotal every occurrence. But it did
do
the trick! Thank you.

"Don Guillett" wrote:

will the SUBTOTAL function help?

--
Don Guillett
SalesAid Software

"SisterDell" wrote in message
...
How do I do this?






All times are GMT +1. The time now is 02:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com