What is the formula to count if a row meets given requirements?

0

Hello, 

I am used to count in a given column. How do I count ina given row. Lets say = COUNT IF (B2:E2, "*")

Tx

Answer
Discuss

Answers

0

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.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login