Google-sheets – How to sum a range based on a condition
google sheets
I have columns with "x" and "o" and I want each "x" in a column count as 0.25 and "o" count as 0.125. How could I do this so I have the sum above each column?
In this example it would be = .25 + .125 + .25 + .125 = 0.75
Adding a sample of you own, helps a great deal to better understand what you mean !!
UPDATE: I've added edit rights to the example file I created, so you can play with it. Changed the names as well, each now being different (makes the auto-complete function work)
Best Answer
The formula you need would be:
OR
Functions used:
COUNTIF