Question

Locked

How to sum up data with dynamic selection using formula in Excel?

By Stephen Lam ·
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!

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Back to Software Forum
2 total posts (Page 1 of 1)  

Software Forums