Aug 31 2020 03:19 AM
HOW DO I CALCULATE A SUM OF DATA FROM MANY SHEETS INTO ONE SHEET IN THE SAME WORKSHEET
Aug 31 2020 03:42 AM
It very depends on how your data is structured and what exactly you'd like to sum. Better to illustrate on sample file.
Aug 31 2020 04:12 AM
@Sergei Baklan it is just weekly data (numbers) for different facilities. I want combine them into monthly data for the consolidated report.it is in five tabs, different numbers for different age groups
Aug 31 2020 05:25 AM
If that's only 5 sheets and structure is always the same, you may use SUMIFS repeated in formula 5 times for every week.
Aug 31 2020 05:34 AM
Aug 31 2020 06:23 AM
Aug 31 2020 07:06 AM
It would help if you could:
Aug 31 2020 07:32 AM
@mathetes I eventually managed to maneuver around and eventually got it. Thanks for the help. I wasn't about the caps thanks
Aug 31 2020 07:34 AM
@Sergei Baklan Thanks so much Sergei, I am sorted, I eventually managed to maneuver around
Aug 31 2020 08:51 AM
So far so good, thanks you updated us.