AverageIF Cross Sheet Data

I am trying to create a cross sheet data where I can calculate what the average 'Trash' amount per site. The problem I am finding is I have multiple sites all within the column so then I can not do a straight average.

Pivot Table

Site Location (Words)

Trash Average (Number)

Site Visit Register Master

Site Location (words)

Litter Level On Site (Number)

I need to grab the information off the Levels of trash per site then average every site to see if the trash is bad per site.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!