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.
no this is for multiple criteria in diff columns, not multiple criteria in same column
-
-
ah gotcha, think it still might work tho: AVERAGEIFS(A1:A10, B1:B10, ">20", C1:C10, "<30")
-
I'm not sure i wanna put in the mental effort to translate this, this looks like it's talking about 3 diff columns
- Show replies
New conversation -
-
-
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.
-
This guy knows what’s up. Also, always use sumifS and averageifS, as there is no downside at all. Extra criteria are optional, but syntax always the same.
End of conversation
New conversation -
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.