Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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