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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!