My spreadsheet has a calculation that compares material available (both in
inventory and ready to ship to a production facility) to material required
for production. The ready to ship materials are packed in containers of
varying quantites. What the following formula is supposed to do is count the
number of containers needed for each material so that the total (in inventory
and shipable) is equal to or greater than the quantity required for
production. There are 60 different materials (rows).

=IF(K37<0,IF(L37=K37*-1,COUNT(L37),IF((L37+M37)=K37*-1,COUNT(L37:M37),IF(SUM(L37:N37)=K37*-1,COUNT(L37:N37),IF(SUM(L37:O37)=K37*-1,COUNT(L37:O37),IF(SUM(L37:P37)=K37*-1,COUNT(L37:P37),COUNT(L37:AC37)))))),0)

Column K shows the quantity of material needed (and is shown as a negative
number).
Columns L-AC show the quantity of material in each container.

I can ship a limit of 24 containers at a time but, if a particular material
requires more than 7 containers, this formula shows the total number of
continers rather than the number needed.

I've looked at some of the solutions that have been offered for similar
problems but did not see one that fit what I was seeking.

Thanks,

ronnnomad