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!
Answers
-
Try below formula,
=COUNTIFS(Grade:Grade, ="K", Grade:Grade, <6, [Life Skills]:[Life Skills], 1)
-
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.
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
No luck :-(
Thank you so much for trying!
-
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)
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
oh wait!! I had a filter on so I think that messed it up. It worked!!
Thank you so much.
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!