Using > (greater than) in this formula

I've tried this several times. I am not a formula guru so this is really on a simple formula on my end. What I am trying to do is just count if the number is greater than 12. I used the same calculation with < = to 6, and I did have results. if I use > 12, I get 0. Here is the formula:

=COUNTIFS({TMO Intake Data Sheet Duration Month}, >6, {TMO Intake Data Sheet Range 2}, "Active", {TMO Intake Data Sheet Range 3}, "Yes", {TMO Intake Data Sheet PA Category}, "Project Management: Coaching of PM Tools, assist with Project Charter Development, Stakeholder Analysis, Work Breakdown Structure, Project Plans, MS Teams Site Set-up.")

Thank you!!

Find more posts tagged with

Accepted answers

Jgorsich

You can just add more criteria to your existing countifs for that (note that there is an implied "and" with every criteria you add.

=COUNTIFS({TMO Intake Data Sheet Duration Month}, >=7, {TMO Intake Data Sheet Duration Month}, < =9,{TMO Intake Data Sheet Range 2}, "Active", {TMO Intake Data Sheet Range 3}, "Yes", {TMO Intake Data Sheet PA Category}, "Project Management: Coaching of PM Tools, assist with Project Charter Development, Stakeholder Analysis, Work Breakdown Structure, Project Plans, MS Teams Site Set-up.")

You can see with those two criteria we are looking for anything that is 7 or larger AND also 9 or less, the net result is just looking for things between 7 and 9.

Luz327

You are the best!! Thank you for your assistance. I was able to use this, and it calculated correctly. I hadn't thought about adding the additional criteria.

All comments

Jgorsich

It looks like the area you are trying to apply the >12 criteria too (based on where the ">6" criteria is in your sample formula) is likely a column that has a =month([some date]@row) type formula in it (based on the name). If that is the case, you are only ever going to get the values 1-12 in that column as it is just assigning a numeric value for the 12 months out of the year. Counting values that only have a month 13 or higher would then result in 0 since there is no 13th month.

If this isn't the issue, please share screenshots and more context.

Luz327

Thank you - I was finally able to make it work. What would I do if I want to use a count of numbers between 7 & 9, so the numbers would be counted if they are 7, 8, or 9? Have no idea how to set up that formula. I did try to do a search and nothing that I saw could I use. I so appreciate your assistance!

Jgorsich

You can just add more criteria to your existing countifs for that (note that there is an implied "and" with every criteria you add.

You can see with those two criteria we are looking for anything that is 7 or larger AND also 9 or less, the net result is just looking for things between 7 and 9.

Luz327

You are the best!! Thank you for your assistance. I was able to use this, and it calculated correctly. I hadn't thought about adding the additional criteria.

Jgorsich

Glad I could help!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.