Good morning,
My goal is to sum cells in column 2018 only when there are non blank adjacent cells in in column 2019.
Can you think of a formula to do that? Do I need to create a new formula in VBA?
Thank you in advance.
<tbody>
</tbody>
My goal is to sum cells in column 2018 only when there are non blank adjacent cells in in column 2019.
Can you think of a formula to do that? Do I need to create a new formula in VBA?
Thank you in advance.
Day | 2019 | 2018 | % Chg |
Mon | 50 | 40 | 25% |
Tue | 50 | 40 | 25% |
Wed | 50 | 40 | 25% |
Thu | 40 | ||
Fri | 40 | ||
Sat | 40 | ||
Sun | 40 | ||
Cum Total Week 1 | 150 | 120 | 25% |
<tbody>
</tbody>