Hi ,

I am looking for a batch script or a excel macro to add/sum a group of numbers to get a SINGLE no. To make it clear I have a list of many nos which need to be added/Sum individually to get a FINAL one digit no.

Eg:- I have a figure 3023456, so I am expecting a summation like 3+0+2+3+4+5+6 = 23 , again 2+3 = 5(Final One Digit Nos).

I shall be very thankful for any suggestion and help.

I am looking for a batch script or a excel macro to add/sum a group of numbers to get a SINGLE no. To make it clear I have a list of many nos which need to be added/Sum individually to get a FINAL one digit no.

Eg:- I have a figure 3023456, so I am expecting a summation like 3+0+2+3+4+5+6 = 23 , again 2+3 = 5(Final One Digit Nos).

I shall be very thankful for any suggestion and help.

## Comment