Formula that sums a column and puts totals of 24 in other columns

Hi All,

I'm looking for help for a formula that sums column "A" that is populated with numbers, and puts a total of 24 from that column into columns b, c, d...etc until all have been allocated.


Thanks in advance

Michael

Can you please post a small sample file showing the expected results.

Click "Go Advanced" the Paper Clip icon: "Add Files", "Browse", "Upload", "Done"

Thanks for replies,

I do have a sheet on what I've been doing, plus a desired end result, which is on the second tab.

Thanks

Hi,

Just wondering has anyone had any luck with this? I've hunted all over google and couldn't find anything.

You mean something like: copypaste in a2:

Please Login or Register  to view this content.

Thanks yumpup,

That doesn't seem to work? Not sure if I have missed something with that formula. The result I am looking for is the formula would look down column F sum to 24 then copy those numbers from column F into column G, then continue to sum to 24 again and copy those from column F into column H, etc.

Hi John,

Thanks very much for your solution. I have had a play around with the sheet and works great.
The only exception is that I have not written any VBA and is out of my league.
While having a look play with the sheet all these #N/A's appeared and I am clueless on how to fix.
I have reattached the file, are you able to have another look at it?

Thanks for your time

Michael

Hi John

Thanks for looking over again, but the attachment appears to be invalid??

Michael

tried once again, worked this time

I can Open/Download O.K.

What error message do you get?

Sorry John,

Doesn't seem to be updating. I have changed some crate amounts, then clicked run, nothing happened. Macros have been enabled, just wondering if im missing something?

Michael

If you are updating "Crate Amounts" then check formulae in E and F.

I simply typed data into F so "destroyed" any formula you had in that column.

I added the formula (=ROUNDUP(E2,0)) at this end and worked OK.

Thanks John,
This is working perfectly, I appreciate your help.

Michael