Forum Discussion
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:$...
As a comment, COUNTIFS returns an array of count for each value in the list of {"New Freshman","Other Transfer","SUNY/CUNY Transfer"}
If you are on Excel which supports dynamic arrays, result will be visible as array. If not, Excel silently takes only first element from this array and shows it.
In both cases to receive all counts array shall be summed as JMB17 suggested.