total number based on cell contents, empty cells are not counted

[Svein Tore Kristensen]

total number based on cell contents, empty cells are not counted

can some specialists help me, thanks in advance

see the attached file

thanks :) 

[#2]

@Svein Tore Kristensen 

Do you use COUNT() or COUNTA()?

[#3]

@Sergei Baklan 

haven't used it, so I don't know

[#4]

@Svein Tore Kristensen 

maybe you can give me the formula :) 

[#5]

@Svein Tore Kristensen 

I'm not sure what will be the function name in you locale, in English one is https://support.office.com/en-us/article/counta-function-7dc98875-d5c1-46f1-9a82-53f3219e2509

to count number of non-empty cells is like =COUNTA(K2:K222) assuming you have empty cells, not cells with empty string "" returned by formula.