How to get the average dates for Delta

Louis.Smith

How to get the average dates for Delta which is located in the client column:

The formula I have is below:

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

The sheet is below:

Nick Korna

Hi @Louis.Smith,

For an average using more than one criteria you need to use AVG & COLLECT:

AVG(COLLECT({Hired Range 1},{Hired Range 3}, {Hired Range 3} > DATE(2023, 3, 1), {Client},"Delta")

I'm not sure which columns your Hired Range 1 & 3 references are referring to, but hopefully this gives you what you're after.

If not, let me know what the issues with it are and we can try and work it out. Hope this helps! ☺️

Louis.Smith

https://community.smartsheet.com/discussion/comment/387112#Comment_387112

It gave me #Invalid Ref

Hired Range 3 is referring to the column where the date range is listed.

Hired Range 1 is the amount that we are getting the average of .

Nick Korna

Have you defined the {Client} reference to tie up with the client column? This can't be typed in, so would need setting up (and renamed if you wished) - all the other references are pre-existing so this is the only thing I can think of that would provide the #Invalid Ref.