Dear All,

Need help !

A
1
1
2
2
1

=Sum(A1:A5) ,Total as output is 7 , I want to split the rang from a formula in another cell

(A1:A5)

if required a scree shot or excel format , i can share ...pls reply.