if i have the below spread sheet. i would be very grateful if anyone could let me know what formula i could use to count non blank spaces. i believe it is the if and then the counta formula, but i can’t seem to get it to work.

any help is very welcomed.

Row No   Column    Column 

                  A               B

1                  1

2                  1              2

3

4                  1

5                  1

6                  1              3

7

8

9                  1

10                1

11                1

12                1              4

I am trying to add the non blank cells that are in column A before they are separated by a blank cell, and have this displayed on Column B.

Any help is welcomed. 

Thanks

Terence

​if i have the below spread sheet. i would be very grateful if anyone could let me know what formula i could use to count non blank spaces. i believe it is the if and then the counta formula, but i can’t seem to get it to work. any help is very welcomed. Row No   Column    Column                   A               B1                  12                  1              234                  15                  16                  1              3789                  110                111                112                1              4 I am trying to add the non blank cells that are in column A before they are separated by a blank cell, and have this displayed on Column B. Any help is welcomed.  Thanks Terence  Read More

​