How to change the formula to get the avg of column if after 1/1/2023
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})
Best Answer
-
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.
Answers
-
Hey @Louis.Smith
=AVERAGEIF(Date1:Date3, Date1:Date3 > DATE(2023, 1, 1), Score1:Score3)
Try this formula,
Let me know if it helped.
Itai Perez
Reporting and Project Manager
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
Please see the sheet below:
The formula I tried to use is:
=AVERAGEIF({Hired Range 1} > DATE(2023, 1, 1))
-
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)
Itai Perez
Reporting and Project Manager
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
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.
-
Can you share a screenshot of the other sheet so I can try asnd write the formula for you?
Itai Perez
Reporting and Project Manager
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!