Formula for 2 criteria

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!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!