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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 06, 2023

ShaneFrancis 

Above words could be located in any cells like

or data is structured somehow?

 

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