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.

Aella

@Aella_Girl

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

2:59 AM · Dec 7, 2020

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.

Replying to

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

Show replies

Replying to

AVERAGEIFS

Replying to

this returns criteria for diff columns, not the same column

Show replies

Thomas Mattimore (tmattimore.eth)

@mattimost

Dec 7, 2020

Replying to

@Aella_Girl

My mistakes with these typically involve not including enough quotations around the criteria in the formula

This Tweet was deleted by the Tweet author. Learn more

no :(

Replying to

You need to use averageifs

Replying to

Does averageifs exist as a function? (it does in excel, and is designed to solve this problem) Failing that, can you add a column called "relevant for my average" and create a nested if function.