im ready to shoot google sheets. Im doin =averageif(b2:b, "CRITERIA", c2:c) but i want "criteria" to cover a range of values, e.g., "3, 4, 5, and 6". I can't figure out how to make it work, is it even possible? Google is letting me down hard.
-
-
You can try adding a hidden auxiliary column with an "if >4 and <8 ="true"" function, then use this column and "true" as your condition.
-
it told me error, but i might not have done it correctly
- Show replies
New conversation -
-
-
Is it 4:8?
- End of conversation
New conversation -
-
-
AVERAGEIFS
-
...is what you want. You can have multiple conditions as arguments
End of conversation
New conversation -
-
-
You need to use averageifs
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
My mistakes with these typically involve not including enough quotations around the criteria in the formula
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
Does averageifs exist as a function? (it does in excel, and is designed to solve this problem) Failing that, can you add a column called "relevant for my average" and create a nested if function.
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.