Formula Help for 2 criteria (checkboxes in two columns) in a CountIfs
I keep getting a #unparseable on my formula, so I am guessing it's just a small formatting error. I need to get a CountIFS using two different columns being "checked".
One is "Approval Confirmed" and the other is "Thank-You Made"
This is the latest formula I've tried:
=COUNTIFS([Approval Confirmed]:[Approval Confirmed], 1) AND(COUNTIFS([Client Thank-You Contact]:[Client Thank-You Contact], 1)
Thank you for the help!
Help Article Resources
Check out the Formula Handbook template!