I have a simple =SUM(A1:G1) formula here but it's not working.
It's like it's missing column data and giving incorrect totals.
Each result (A:G) is populated by an IF formula.
Any thoughts why Sum would not be working properly?
Auto Calculation is on, which is the only thing i can think of to check.
<colgroup><col style="width:48pt" span="8" width="64"> </colgroup><tbody>
</tbody>
It's like it's missing column data and giving incorrect totals.
Each result (A:G) is populated by an IF formula.
Any thoughts why Sum would not be working properly?
Auto Calculation is on, which is the only thing i can think of to check.
PROD | SRPHR | XSPHR | IBPHR | Rev Kck | XS Rev | Rev/Dispo | Totals |
1 | 3 | 1 | 1 | 1 | 1 | 1 | |
1 | 3 | 3 | 1 | 1 | 1 | 4 | 5 |
6 | 1 | 3 | 1 | 1 | 1 | 6 | 12 |
<colgroup><col style="width:48pt" span="8" width="64"> </colgroup><tbody>
</tbody>