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.
Conversation
Replying to
a range in one direction works = "<8" is fine, but I can't make it do ">4, <8"
7
8
Show replies
Replying to
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
Show replies
Replying to
no this is for multiple criteria in diff columns, not multiple criteria in same column
2
Show replies