I am trying to get a max count of multiple columns (C,D,E) on the attached. Currently the formula I have(=MAX(COUNTIFS(Assessment!$A$3:$A$97,J9,Assessment!$C$3:$C$97,">0"),COUNTIFS(Assessment!$A$3:$A$97,J9,Assessment!$D$3:$D$97,">0"),COUNTIFS(Assessment!$A$3:$A$97,J9,Assessment!$E$3:$E$97,">0"))) is giving me 9 counts which is not accurate since the count on the attached should be 10. Thanks for your help.
Bookmarks