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.
-
-
It depends on if you want logical AND or ORpic.twitter.com/4tvz2O6n8J
-
=AVERAGEIFS (avg_rng, range1, criteria1, [range2], [criteria2], ...) You can use the same range, just change the criteria to suit your needs. This is excel. You can do it in excel then upload to sheets
- Show replies
New conversation -
-
-
For example, =AVERAGEIFS(H2:H10, G2:G10, ">0", B2:B10, "<1.0") will give you the average of only those cells in the H column's range whose counterparts in G column are positive AND counterparts in B column are less than 1.
-
It is weird to see this done with a spreadsheet and have it be such a struggle. The criteria should be an arbitrary expression that results in true or false and the cell it's operating on should be represented in the expression by 'x' or something.
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.