Forum Discussion
Annie_WG
Feb 19, 2025Copper Contributor
COUNTIFS a person has completed their job
- OliverScheurichGold Contributor
This returns the expected results in my sample file.
=COUNTIFS($B$2:$B$6,B9,$C$2:$C$6,"<>done",$D$2:$D$6,"<>done",$E$2:$E$6,"<>done") =COUNTIFS($B$2:$B$6,B9)