How to change the formula to get the avg of column if after 1/1/2023

Louis.Smith · 07/25/23

The formula I have is pulling all the dates but I want only get the avg of the cell if date is after 1/1/23:

=AVG({Hired Range 1})

Louis.Smith · 07/25/23

Hired Range 1 is a column in the sheet I am pulling data from.

The value returned was 0 but I don't think that is correct.

Itai · 07/25/23

=AVERAGEIF(Date1:Date3, Date1:Date3 > DATE(2023, 1, 1), Score1:Score3)

Try this formula,

Let me know if it helped.

Louis.Smith · 07/25/23

Please see the sheet below:

The formula I tried to use is:

=AVERAGEIF({Hired Range 1} > DATE(2023, 1, 1))

Itai · 07/25/23

Hey,

What is Hired range 1? look at the formula's syntex. you need to have 2 parts to it, first one is the range, the the criteria.

=AVERAGEIF({Hired Range 1}, {Hired Range 1} > DATE(2023, 1, 1), Whatever you need to be averaged)

Louis.Smith · 07/25/23

Hired Range 1 is a column in the sheet I am pulling data from.

The value returned was 0 but I don't think that is correct.

Itai · 07/25/23

Can you share a screenshot of the other sheet so I can try asnd write the formula for you?

Best Answer