Counting specific values in a column

Mike P

Hi, This should be easy...

I am trying to sum up the number of single rooms and the number of double rooms and I can't get it to work.

I just want it to count how many "SGL" and separately how many "DBL"

Any advice?

Thank you.

Mike

Lucas Rayala

Hi @Mike P - adjust the ranges in the below formulas, but it should just be:

For Single Rooms

=COUNT([Room Type]1:[Room Type]26, "SGL")

For Double Rooms

=COUNT([Room Type]1:[Room Type]26, "DBL")

Mike P

Thank you Lucas - I needed to change it to COUNTIF, but other than that, it worked! Thank you so much.

Lucas Rayala

Hi @Mike P - adjust the ranges in the below formulas, but it should just be:

For Single Rooms

=COUNT([Room Type]1:[Room Type]26, "SGL")

For Double Rooms

=COUNT([Room Type]1:[Room Type]26, "DBL")

Mike P

Thank you Lucas - I needed to change it to COUNTIF, but other than that, it worked! Thank you so much.

Lucas Rayala

Ha! Rushed myself apparently. Glad you got it working.