CODEWITHSUNDEEP
excelexcel-formulacountif
user1527227
user1527227

Reputation: 2248

Excel Countif - parsing arguments with functions without helper row

I'm trying to use countif function to count the number of bedrooms on a large rent roll sheet (hundreds of entries).

Is it possible to do this without using a helper column? I tried but get an error. Not sure why.

Thank you.

enter image description here

Upvotes: 1

Views: 112

Answers (1)

BigBen
BigBen

Reputation: 50007

Use a wildcard:

=COUNTIF($B$2:$B$7,E3&"x*")

enter image description here

*Included the x just in case the number of bedrooms goes past 9, but you might be able to drop it.

For more detail on why COUNTIF with an array doesn't work, see this question.

Upvotes: 3

Related Questions