Feb 18 2019 03:19 AM
I have a pivot table that contains towns and their postcode, with a count of the number of occurrences. Table 2 contains 3 columns- local council area, towns and postcodes. The end result I want is a formula to calculate the number of occurances in each local council area. What formula do I use? Really need to work this out in the next 24 hours. Help please? KB
Feb 18 2019 04:07 AM
SolutionSee if the attached helps:
It uses SUMIFS formula
Feb 18 2019 04:07 AM
Solution