finnstone

asked on

# criteria for 1 column for average of 2nd column

i need to do a conditional average formula.

in col B, i have a bunch of data.

in col A, I have a date.

i want a formula that looks at col a, makes sure anything after 1/1/2018 is no counted, and so only takes an average of values col B where col A is before 2018.

in col B, i have a bunch of data.

in col A, I have a date.

i want a formula that looks at col a, makes sure anything after 1/1/2018 is no counted, and so only takes an average of values col B where col A is before 2018.

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
=AVERAGEIF(A2:A6,"<="&VALU