Hi All,
New to the forum and hoping that you all can help. Started working on something yesterday that I thought would be simple but has proven tricky. I need to sum the YTD total for a given line in an excel sheet. I am able to reference the condition and month number, but would need it to sum that month and previous months. Any help would be appreciated.
I am trying to write a formula that would allow me to reference condition 2 and sum YTD through month 3, which would give me a total of 150. Is this possible? I already tried a sumif and got a value error...
Thanks
<tbody>
</tbody>
New to the forum and hoping that you all can help. Started working on something yesterday that I thought would be simple but has proven tricky. I need to sum the YTD total for a given line in an excel sheet. I am able to reference the condition and month number, but would need it to sum that month and previous months. Any help would be appreciated.
I am trying to write a formula that would allow me to reference condition 2 and sum YTD through month 3, which would give me a total of 150. Is this possible? I already tried a sumif and got a value error...
Thanks
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
Condition 1 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |
Condition 2 | 50 | 50 | 50 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |
Condition 3 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |
Condition 4 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |
<tbody>
</tbody>