I have a spreadsheet with the following columns:
Name Location Rating If
Joe Canada Target 2
Fred Canada Below Target 3
James France Above Target 1
Mary UK Target 2
Sam USA Above Target 1
Jane USA Above Target 1
On the next three sheets I have the following tables created to populate graphs using the values from the frequency equation for the number of ratings for each Location.
Rating Value Frequency
Below Target 1
Target 2
Above Target 3
For the first sheet I am using the Frequency formula to populate how many 1s are on the first spreadsheet and how many 2s and 3s for Canada
But I have to sort the first spreadsheet by the location column and only include the rows with Canada as a location.
Is there a way that I can populate the frequency formula to search all rows in the first spreadsheet and return the number of 1s, 2s 3s for a specific location? If the first spreadsheet is sorted another way the graphs will be incorrect.
Hope this is clear. I have attached a sample file Excel Location_Rating Graph tabs.xlsx
Thanks
Bookmarks