Sundance_Kid
Board Regular
- Joined
- Sep 2, 2017
- Messages
- 155
- Office Version
- 365
- Platform
- Windows
Hi,
I have multiple tabs with data & on each tab there is a column with the dates and another column with the value of sales on that day.
I want to have an overall summary tab, where it will total the value of sales across multiple products (on the multiple tabs) for each date.
What is the best formula to do this?
One slight issue, is that for most of the tabs the value will be in the same column - say column H, however there will be a couple of tabs where the value is in cell J.
Thank you
I have multiple tabs with data & on each tab there is a column with the dates and another column with the value of sales on that day.
I want to have an overall summary tab, where it will total the value of sales across multiple products (on the multiple tabs) for each date.
What is the best formula to do this?
One slight issue, is that for most of the tabs the value will be in the same column - say column H, however there will be a couple of tabs where the value is in cell J.
Thank you