Hello Ladies & Gentlemen,
I've got a sheet contains lengthy numbers. Each set of numbers separated with blank cell for totals. I'd like to sum up these numbers in the blank cell but I need to go to each group of numbers to do that.
Is there any idea to quickly sum up these numbers without having to go to each one of them.
i.e: These numbers are located from cell (A1 : A5)
1235
252
422
322
200
Then(A6) is blank for total.
From cell (A7:A9)
5000
455
788
Then(A10) is blank for total.
and so on...
Thanks.
I've got a sheet contains lengthy numbers. Each set of numbers separated with blank cell for totals. I'd like to sum up these numbers in the blank cell but I need to go to each group of numbers to do that.
Is there any idea to quickly sum up these numbers without having to go to each one of them.
i.e: These numbers are located from cell (A1 : A5)
1235
252
422
322
200
Then(A6) is blank for total.
From cell (A7:A9)
5000
455
788
Then(A10) is blank for total.
and so on...
Thanks.