COUNT PROBLEM

[nazmul_bd08]

Example


col a.........col b.........col c.......col d..........col f(result)

.....3..............1..............5............6..............=7 (result)

however col a col b col c col d in any number but result col f display all col count 2 and 1 other element not count

 

[keymaster]

I am not sure I understand your question.


Please note that COUNT formula only counts numbers in a range.

if you want to count all values (including text etc.), use COUNTA

 

[cacos]

Try typing this in column F (I assume it's F1): =counta(A1:E1)


It will count all cells that are not empty

 

[SirJB7]

@KM

Hi!

Hmmm... cofff cofff... Are you sure you're feeling fine today? Should I call your doctor?

:=)

Regards!

 

[nazmul_bd08]

actually

col a col b col c col d input any number but col f display addition 2 and 1 from those all col another number not add

example

col a ,,,,,,,,,,,,,col b,,,,,,,,col c,,,,,,,,,col d,,,,,,,,,col f

,,,,5,,,,,,,,,,,,,,,,,,6,,,,,,,,,,,,3,,,,,,,,,,,,,4,,,,,,,,,,,,,col f display 8

,,,,1,,,,,,,,,,,,,,,,,,2,,,,,,,,,,,,8,,,,,,,,,,,,,6,,,,,,,,,,,,,,col f disply 7

 

[SirJB7]

Hi, nazmul_bd08!

Would you please elaborate a bit more and explain yourself in other words? Both posts are similar but they're still unintelligible for me. Thank you.

8 and 7 are the only values that cells in column F could have? How do you calculate this cells?

Regards!