Hello,
I am used to count in a given column. How do I count ina given row. Lets say = COUNT IF (B2:E2, "*")
Tx
Hello,
I am used to count in a given column. How do I count ina given row. Lets say = COUNT IF (B2:E2, "*")
Tx
All the COUNT functions apply themselves to a range which might be vertical (A1:A5) or horizontal (A1:E1) or 2-dimensional (A1:E5), even non-contiguous, like
=COUNT(A1:A5, E1:E5)
Use COUNT to count cells which contain numbers, COUNTA to count cells which aren't blank and COUNTBLANK to count blank cells.
Apply the same logic to COUNTIF and COUNTIFS.