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

question by: Hamza Ergin

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/EIsO2BJifn4;context-place=forum/docs

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