Split sum group

Hi everyone,

Can I use the excel formula to split the sum that amount around 600 in 1 group.

Let say I have 9 amount

A1 = 100
A2 = 200
A3 = 100
A4 = 100
A5 = 200
A6 = 100
A7 = 100
A8 = 200
A9 = 70

can I use formula to split A1, A3, A4, A6, A7, A9 in 1 group that total sum around 600, another group is A2, A5, A8 ?

Thanks in advanced.

Thanks for your reply.

I want the formula can auto arrange the total amount around 600 in 1 group, for example it will auto remark that A1, A3, A4, A6, A7, A9 is group 1, A2, A5, A8 is group 2

Thanks for advanced