Formula for 2 criteria

TracyM

Hi,

I'm trying to come up with a formula to count all the students in grades K, 1, 2, 3, 4, 5 who are also in our life skills program.

I have the formulas separate =COUNTIFS(Grade:Grade, ="K") + COUNTIF(Grade:Grade, <6)

=COUNTIF([Life Skills]:[Life Skills], 1)

I tried =COUNTIFS(Grade:Grade, ="K") + COUNTIF(Grade:Grade, <6) AND ([Life Skills]:[Life Skills], 1) but that didn't work

But I can't figure out how to put them together to make it work. Thanks for any help you can provide!

Ibrahim Khaleel

Try below formula,

=COUNTIFS(Grade:Grade, ="K", Grade:Grade, <6, [Life Skills]:[Life Skills], 1)

TracyM

That got me a little closer - it didn't come up as an error, but the total is coming up as 0, but there should be 27.

Andrée Starå

Hi @TracyM

I hope you're well and safe!

Try something like this.

=
COUNTIFS(Grade:Grade, "K", [Life Skills]:[Life Skills], 1) + 
COUNTIFS(Grade:Grade, <=5, [Life Skills]:[Life Skills], 1)

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

TracyM

No luck :-(

Thank you so much for trying!

Andrée Starå

@TracyM

Strange! It should work, or at least it's working for me!

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

TracyM

oh wait!! I had a filter on so I think that messed it up. It worked!!

Thank you so much.

Andrée Starå

@TracyM

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!