Using > (greater than) in this formula

Luz327

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!!

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.

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.

=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.

Jgorsich

Glad I could help!