Formula for 2 criteria


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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!