Averaging years based on name
I am trying to average the number of years old an item is per division. I have a column that is already calculating age and column for the division. I feel like this should be an easy formula but when I the following formula I get an #UNPARSEABLE error. Can someone help me figure out what I am doing wrong?
The tracker range 1 is the division column on another sheet and the Range 2 is the column for age (in years).
=AVERAGEIF({IT Hardware Tracker Range 1} = "Realty",{IT Hardware Tracker Range 2}:{IT Hardware Tracker Range 2})
Answers
-
Hi @Dhoke
Were you able to figure this out? Cross sheet reference formulas have slightly different formatting than in-sheet formulas.
Here's the structure for an AVERAGEIF in general:
In your case, I would re-write the formula like so:
=AVERAGEIF({IT Hardware Tracker Range 1}, "Realty", {IT Hardware Tracker Range 2})
This is assuming "Range 1" is the one with "Realty", and "Range 2" is the column to Average. Remember that with cross-sheet references, you'll want to click on the column name to create the reference so it includes new rows in the future. 🙂
Here are some resources that may be helpful for you:
Cheers,
GenevieveNeed more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!