Question Locked
How to sum up data with dynamic selection using formula in Excel?
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hello all,
How to sum up the data with dynamic selection using formula in Excel?
For example:
In row 1, I wanted sum up columns A, B, C, D, E, F, G, H values but I want to skip column D.
In row 2, I wanted sum up columns A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q values but I want to skip column J
???.
???..
As there are 1,000 records, could anyone advice how to do that in effective way? Many thanks for your help!