What would be the best way to sum multiple cities in the same region for turnovers of each year .. for comparison on a different worksheet?
SUMIF?
needs to be done on this spreadsheet
Region Help.xlsm
What would be the best way to sum multiple cities in the same region for turnovers of each year .. for comparison on a different worksheet?
SUMIF?
needs to be done on this spreadsheet
Region Help.xlsm
If you remove the empty columns you can use Pivot Table
If you are happy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks