Avatar of 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.
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon