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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!