Saturday, January 21, 2012

yogi_Count Number Of Specified Entries In Specified Cells Row By Row

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

user lavaman101 said:
So ive got a spreadsheet where the possible answers are either an "L", "A", or "W"... i want to be able to create a sum of each type of letter in each row... so a sum of all the "L"'s in one cell... and a sum of "A" in a different cell, etc. 
I was thinking an IF statement would work... and it does for 1 cell... but not for an array of cells.  I tried =IF((C4:H4="L",1,0))
Any help would be great! 
following is a solution to the problem