ExcelBanter - how to account the number of cells which is bank and written?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to account the number of cells which is bank and written? (https://www.excelbanter.com/excel-discussion-misc-queries/141925-how-account-number-cells-bank-written.html)

jack

how to account the number of cells which is bank and written?

Gord Dibben

how to account the number of cells which is bank and written?

Jack

=COUNTA(range) will count the non-blank cells in range.

Gord Dibben MS Excel MVP

On Tue, 8 May 2007 00:35:30 -0700, jack wrote:

All times are GMT +1. The time now is 06:56 PM.