detect a filled out cell

A

Alain R.

Hi,

I would like to check a column.
If a cell has text, i want to increase a counter.
could it be done using SUMIF ?

something like SUMIF(Page1!A:A;cell <>"";total=total+1)

i don't want to use VBA
thanks,
Alain
 
N

Niek Otten

Hi Alain,

=COUNTIF(A:A,"<>")

It will count all non-empty cells, also numbers

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
Merging from an Excel file with graphics 1
detection of cell contents 1
Excel does not accept text format! 0
Word macro that can call cells out of Excel for a find and replace 0
Another Running Totals Problem 9
Question about SUMIFS(A:A,...) 3
Sumif all Null Values 8

Top