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

Hi John

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

Michael

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