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.
I'm not sure i wanna put in the mental effort to translate this, this looks like it's talking about 3 diff columns
-
-
You can use the same criteria range in both places =AVERAGEIFS(B2:B10, C2:C10, “>4”, C2:C10, “<8”) will average values in column B where values in column C are 5 - 7.
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.