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

Find more posts tagged with

Accepted answers

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.

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.