Formula

B

Baderinwa3

I need a formula to count. I am working on an inventory list. We sell by the
boxes but our supplier orders by number in each box. There is 100 in each
box. I need for a cell to count every 100 and reference it as being 1 box.
 
T

Toppers

Perhaps an example of your data and results wanted;

Number of boxes:

=If (MOD(count of items,100)=0,INT(count of items)/100),INT(count of
items)/100)+1)
 
Top