How can I count items only when 3 specific criteria are met?
Novice user here -
I am building a data sheet for metrics and am hoping someone could please help me figure out the best way to create a COUNTIF/IFS formula that will only count a status 'type' (Complete, Scheduled, etc.) if the Core OpCo is 'FLA' and the year is 2022 and the LFCM OT box is 'checked/True'?
I'm not sure where to begin, or if using COUNTIF/IFS is the correct way to go about it?
Help Article Resources
Check out the Formula Handbook template!