Forum Discussion

ShaneFrancis's avatar
ShaneFrancis
Copper Contributor
Nov 06, 2023

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...
excel
Formulas and Functions
ShaneFrancis's avatar
ShaneFrancis
Copper Contributor
Nov 13, 2023

SergeiBaklan 

 

Data structured see attached thanks for helping

 

 

 

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 13, 2023

ShaneFrancis 

So, "Clinic visit", if appears, always in C1 and it is applied to all names in that column, not only to Berwick?

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 16, 2023

      ShaneFrancis 

      As variant

      =IF( $C$1="Clinic visit", COUNTIF($A$2:$B$9, "berwick"),  COUNTIF($A$2:$D$9, "berwick") )

Resources