Saturday, December 16, 2017

yogi_Row By Row Count Of 'Y' In Range A2:C

Google Spreadsheet   Post  #2321

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-16-2017

How to use ArrayFormula and Countif on each row Calc Column

Hi, sir
I want write a formula in D1, it is calculate below result
D1 = Count of Y Column = ArrayFormula( Countif(A1:C; "=Y")  )   for each row count of 'Y'

My Table
A Colum - B Column - C Column - D1 Count of Y Column = ArrayFormula(Countif(???))
-----------    -----------      -----------      -----------  
Y               N                 Y                2
N               N                 Y               1
N               N                 N               0
Y               Y                 Y               3