Forum Discussion

Copper Contributor

Feb 08, 2017

COUNTIF formula question

I need help with this formula I have been working on: =COUNTIFS(B7:B202,"4OB",(F7:F202,"y"),(F7:F202,"Y - Prior Admin"),(F7:F202,"Y - Pt refused"))/(COUNTIF(E7:E202,"Y")+COUNTIF(D7:D202,"N")) Col...

Formulas & Functions

Need Help

SergeiBaklan

Diamond Contributor

Feb 09, 2017

Andrew, perhaps something like this

=SUM(
   COUNTIFS(
      B7:B202,"4OB",
      F7:F202,{"y","Y - Prior Admin","Y - Pt refused"}
   )
 )/
 (COUNTIF(E7:E202,"Y")+COUNTIF(D7:D202,"N"))