I figure there's a pretty simple formula to resolve this.
I would like Excel to Sum only 1 non-blank cell per row, based on a column priority.
Column Priority in the sample below is E/C/D/A/B
So, the process would be:
Excel checks E2 (blank), then moves to C2 (blank), then moves to D2 (3) and stops.
Then in the next row, it checks E3 (blank), then moves to C3 (13) and stops.
In the 3rd row, it checks E4 (8) and stops.
In row 4, it checks E5 (1) and stops.
In row 5, it checks E6 (blank), then moves to C6 (11) and stops.
In row 6, it checks E7 (blank), then C7 (blank), then to D7 (blank), then to A7 (blank), then to B7 (7) and stops.
Excel adds 3+13+8+1+11+7 = 43
a b c d e 12 10 3 11 6 13 6 8 8 9 25 1 5 17 11 8 7
Your help with this is much appreciated!
Bookmarks