body { -ms-overflow-style: scrollbar; overflow-y: scroll; overscroll-behavior-y: none; } .errorContainer { background-color: #FFF; color: #0F1419; max-width: 600px; margin: 0 auto; padding: 10%; font-family: Helvetica, sans-serif; font-size: 16px; } .errorButton { margin: 3em 0; } .errorButton a { background: #1DA1F2; border-radius: 2.5em; color: white; padding: 1em 2em; text-decoration: none; } .errorButton a:hover, .errorButton a:focus { background: rgb(26, 145, 218); } .errorFooter { color: #657786; font-size: 80%; line-height: 1.5; padding: 1em 0; } .errorFooter a, .errorFooter a:visited { color: #657786; text-decoration: none; padding-right: 1em; } .errorFooter a:hover, .errorFooter a:active { text-decoration: underline; } #placeholder, #react-root { display: none !important; } body { background-color: #FFF !important; }

JavaScript is not available.

We’ve detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our Help Center.

Terms of Service Privacy Policy Cookie Policy Imprint Ads info © 2023 Twitter, Inc.

Conversation

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.

19

1

25

a range in one direction works = "<8" is fine, but I can't make it do ">4, <8"

7

8

Replying to

You can try adding a hidden auxiliary column with an "if >4 and <8 ="true"" function, then use this column and "true" as your condition.

1

1

Replying to

it told me error, but i might not have done it correctly

3:02 AM · Dec 7, 2020

Replying to

and

This is a standard work-around for this and similar issues in excel/google sheets. I use binary (1/0) in the extra “flag” column instead of True/False. Then averageif based on the flag column.

1