Averaging years based on name

Dhoke

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})

Genevieve P.

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: https://help.smartsheet.com/function/averageif

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:

• Create cross-sheet references
• Cross-sheet formulas
• Formula Foundations webinars

Cheers,
Genevieve