AverageIF Cross Sheet Data

Archie123456

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.

Paul Newcome

Are you able to provide some screenshots for context?

Archie123456

Hi Paul

There are 2 different tables within this expression. I want the Average trash per location. Off initial trying this would involve an =AverageIF statement to grab the information average if the information is the same as the location criteria such as 'London'. Shown below on the screenshots. If anymore clarity is needed please let me know.

Paul Newcome

Did the AVERAGEIF not work for you?

Archie123456

No I could not get it to work. Do you have an example of what the AVERAGEIF formula would look like?

Paul Newcome

Give this a read. If you are still finding it a challenge, feel free to post what you have tried along with the outcomes.

https://help.smartsheet.com/function/averageif