Dear All,
I am stuck and need a little help. Seems like a simple problem.
I have a list. Every day we get sales data from different locations. Each location gets one row. Then data goes in the subsequent columns. The number of rows is dynamic depending on how many locations reported for that day.
Here is the structure:
Column A has date, Column B has serial numbers of data points for that date, Column C has location, Column D through K has data for that location.
For each date, the row after the last location has totals. Here is the issue. Since the number of rows to total come from Column B (Column B is reset at 1 for each date), how do I create a SUM formula to add n number of rows when n is a value in one row above and two columns to the left?
Thank you
Sam
I am stuck and need a little help. Seems like a simple problem.
I have a list. Every day we get sales data from different locations. Each location gets one row. Then data goes in the subsequent columns. The number of rows is dynamic depending on how many locations reported for that day.
Here is the structure:
Column A has date, Column B has serial numbers of data points for that date, Column C has location, Column D through K has data for that location.
For each date, the row after the last location has totals. Here is the issue. Since the number of rows to total come from Column B (Column B is reset at 1 for each date), how do I create a SUM formula to add n number of rows when n is a value in one row above and two columns to the left?
Thank you
Sam