Adding columns containing text

Closed
bsteen Posts 1 Registration date Monday 24 June 2013 Status Member Last seen 24 June 2013 - 24 Jun 2013 à 09:15
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 24 Jun 2013 à 11:51
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 12 September 2010 Status Contributor Last seen 27 December 2022 555
24 Jun 2013 à 11:51
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