Adding columns containing text

Closed
bsteen Posts 1 Registration date Monday June 24, 2013 Status Member Last seen June 24, 2013 - Jun 24, 2013 at 09:15 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 24, 2013 at 11:51 AM
I have a basic sheet and cell a4 is a total of jobs done. I want to add +1 to cell a4 every time I enter any text in b6:b1000 to tally work completed.

What is the formula for this?

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jun 24, 2013 at 11:51 AM
Hi Bsteen,

The formula COUNTA will count the cells with data in a specific range.

So your formula would look like:
=COUNTA(B6:B1000)

Best regards,
Trowa
0