Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
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
No comments:
Post a Comment