Hi, I can't figure this formula out.

I want to put =COUNTIF(Sheet1.O17:O206; "=Y") in an IF formula that counts Sheet1.D17:D206 only if the value is "On".

Count how many times "Y" is in the cell range O12:O206 only if the cells in the range D17:D206 have the value On.

So something like =IF(Sheet1.D17:D206 = "On"; COUNTIF(Sheet1.O17:O206; "=Y");""))