Forum Discussion

Terence019740's avatar
Terence019740
Copper Contributor
Apr 27, 2024
Solved

what formula can i use to count non blank cells

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 ca...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Apr 27, 2024

    Terence019740 

    In B2:

     

    =IF(AND(A2<>"", A3=""), COUNTA(A$1:A2)-SUM(B$1:B1), "")

     

    Fill down.

HansVogelaar's avatar
HansVogelaar
MVP
Apr 27, 2024

Terence019740 

In B2:

 

=IF(AND(A2<>"", A3=""), COUNTA(A$1:A2)-SUM(B$1:B1), "")

 

Fill down.

Resources