IF statement for simple hours calculation spreadsheet

[ajcgoldrush]

Hi,

I'm trying to install an "IF" statement on a simple spreadsheet where the employee puts in a simple "Y" or "N" if an associate worked a particular day (Monday to Sunday 2 week period therefore 15 days). I currently have this for one day =IF(C4="Y",1,0) but would like to encompass all 15 columns (C4 to Q4) for a total days worked, not just one. I currently just have used the row below each column and then did a sum in column R using this =SUM(C5:Q5).
What are my options to just use the row 4 "Y" or "N" in column R instead?

Thanks,

AJ

 

[etaf]

you could use a COUNTIF() and count how many Y there are

=Countif(C4:Q4,"Y")
that will count how many Y's are in the row 4 from column C to Q

 

[ajcgoldrush]

That seems to have worked, I tried COUNTIF but had too many arguments...yours is perfect...Thank You!

 

[etaf]

you are welcome