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.
-
Show this thread
-
Replying to @Aella_Girl
Maybe easier to create an additional column with a TRUE/FALSE value based on your criteria and then to the average if the value is true :)
1 reply 0 retweets 0 likes
Replying to @eliaschedid
yea i've been doin basically that but i want a faster way
7:03 PM - 6 Dec 2020
0 replies
0 retweets
1 like
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.