Hello all,
I'm hoping the experts here can point me in the right direction for what I need to do
Here's the situation: I have an excel file that tracks production of multiple products by the week and it's set up essentially like this:
<tbody>
</tbody>
What I'm trying to do is to create a formula that will give me the sum total of all the times each product has been over produced and under produced so I'd have something like the following (which I have set up on another sheet in the same workbook):
<tbody>
</tbody>
What I'm struggling with is the formula for this since it's a range that covers multiple columns. Is there a way to do this without writing a formula that references each individual column to be summed?
Any advice would be greatly appreciated, I've been beating my head against a wall for a couple of week trying to create a usable format.
I'm hoping the experts here can point me in the right direction for what I need to do
Here's the situation: I have an excel file that tracks production of multiple products by the week and it's set up essentially like this:
| Product Name | Week 1 Over | Week 1 Under | Week 2 Over | Week 2 Under |
| Product 1 | 0 | 2 | 1 | 0 |
| Product 2 | 1 | 0 | 1 | 1 |
| Product 3 | 1 | 1 | 2 | 0 |
<tbody>
</tbody>
What I'm trying to do is to create a formula that will give me the sum total of all the times each product has been over produced and under produced so I'd have something like the following (which I have set up on another sheet in the same workbook):
| Product Name | Over | Under |
| Product 1 | 1 | 2 |
<tbody>
</tbody>
What I'm struggling with is the formula for this since it's a range that covers multiple columns. Is there a way to do this without writing a formula that references each individual column to be summed?
Any advice would be greatly appreciated, I've been beating my head against a wall for a couple of week trying to create a usable format.
