Forum Discussion
multiple criteria to select number
I have one data set COUNTIFS(A1:D10, Berwick) If Berwick appears it would be classed as 1 In a the same formula set, I would like to count : E1:F10 when "Berwick" and "Clinic visit" appear if th...
SergeiBaklan yes correct
As variant
=IF( $C$1="Clinic visit", COUNTIF($A$2:$B$9, "berwick"), COUNTIF($A$2:$D$9, "berwick") )thankyou SergeiBaklan