Forum Discussion
Sorting data on multiple sheets
Hi, I'm using Excel to track data from my team for analysis. I have 5 sheets in my workbook one for each week and a monthly overview. each week totals all data and totals are added to overview ...
Donsclan​ So may I assume that you are using a regular SUM function that points to cells for specific individuals in the weekly sheet? If so, look into using SUMIF or SUMIFS instead. These functions allow you to sum values in an entire range based on criteria in another range or other ranges.
But perhaps better to get rid of the weekly sheets all together and create one table with whatever you are tracking, in a tabular lay-out. Much easier to analyse/summarise than data in separate sheets.