a range in one direction works = "<8" is fine, but I can't make it do ">4, <8"
-
-
Show this threadThanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
Or statement
-
Or if doing a range, an And statement
End of conversation
New conversation -
-
-
what u doin in gooogol sheets
-
figurin out how hoes earn money
- Show replies
New conversation -
-
-
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 :)
-
yea i've been doin basically that but i want a faster way
End of conversation
New conversation -
-
-
Have you try the AND (Criteria1, Criteria2) or OR (Criteria1, Criteria2)
-
And for more than 2 criteria. It gets a little messy like this. OR(Criteria1, OR(Criteria2, Criteria3))
End of conversation
New conversation -
-
-
AVERAGEIFS should allow multiple criteria
- Show replies
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.