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?

Resources