SOLVED
Home

Formula HELP!!

%3CLINGO-SUB%20id%3D%22lingo-sub-352444%22%20slang%3D%22en-US%22%3EFormula%20HELP!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352444%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20pivot%20table%20that%20contains%20towns%20and%20their%20postcode%2C%20with%20a%20count%20of%20the%20number%20of%20occurrences.%20Table%202%20contains%203%20columns-%20local%20council%20area%2C%20towns%20and%20postcodes.%20The%20end%20result%20I%20want%20is%20a%20formula%20to%20calculate%20the%20number%20of%20occurances%20in%20each%20local%20council%20area.%20What%20formula%20do%20I%20use%3F%20Really%20need%20to%20work%20this%20out%20in%20the%20next%2024%20hours.%20Help%20please%3F%20KB%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-352444%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-353575%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20HELP!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-353575%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much%2C%20this%20worked.%20Was%20tearing%20my%20hair%20out%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-352464%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20HELP!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352464%22%20slang%3D%22en-US%22%3E%3CP%20style%3D%22text-align%3A%20left%3B%22%3ESee%20if%20the%20attached%20helps%3A%3C%2FP%3E%0A%3CP%20style%3D%22text-align%3A%20left%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22text-align%3A%20left%3B%22%3EIt%20uses%20SUMIFS%20formula%3C%2FP%3E%3C%2FLINGO-BODY%3E
Kazbo72
New Contributor

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

2 Replies
Solution

See if the attached helps:

 

It uses SUMIFS formula

Thank you so much, this worked. Was tearing my hair out
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies