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.
Answers
-
Are you able to provide some screenshots for context?
-
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.
-
Did the AVERAGEIF not work for you?
-
No I could not get it to work. Do you have an example of what the AVERAGEIF formula would look like?
-
Give this a read. If you are still finding it a challenge, feel free to post what you have tried along with the outcomes.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!