Forum Discussion

Copper Contributor

Oct 09, 2020

COUNTIFS with OR conditions

I am trying to count text values using the following formula. =COUNTIFS(Roster!$C:$C, "Female", Roster!$D:$D,{"New Freshman","Other Transfer","SUNY/CUNY Transfer"},Roster!$F:$F, $B26, Roster!$G:$...

excel

Formulas and Functions

training

JMB17

Bronze Contributor

Oct 09, 2020

Try wrapping it with the sum function:

=SUM(COUNTIFS(Roster!$C:$C, "Female", Roster!$D:$D,{"New Freshman","Other Transfer","SUNY/CUNY Transfer"},Roster!$F:$F, $B26, Roster!$G:$G,"LLDB"))