Calculating Cell Occupation
Hi All In cell C20 I need to put the amount of cells in the range D6 - D17 which have content. It's not the total of the content , simply to register how many of the cells in the range have anything in them. If three are occupied then C20 should read three , and so on. Can someone help with a formula? Grateful for any advice. Best Wishes |
Calculating Cell Occupation
=COUNTA(D6:D17)
-- Gary''s Student - gsnu200903 |
Calculating Cell Occupation
In article , Gary''s
Student writes =COUNTA(D6:D17) - OK that's perfect. Thanks for your help. Best Wishes |
All times are GMT +1. The time now is 03:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com