I have a spreadsheet where I have columns called Shipment 1, Shipment 2 up
to Shipment 5. The shipments come in 1 mg vials or 10 mg vials. I placed
columns next to each shipment column named €œ1 mg€� and €œ10 mg€�. I put a
checkbox in each cell and linked it to the cell. So if the shipment contained
1 mg vials I would click that, if the shipment contained 10 mg. vials, I
would check that. I then have a column that says €œTotal Shipments-1 mg€� and
€œTotal Shipments €“ 10 mg€�. How do I get excel to add the 1 mg shipments and
the 10 mg. shipments separately in their columns. For example, excel will add
only the shipments that the check box is checked in the 1 mg. column to the
Total Shipments €“ 1 mg column. There are other columns in between these
columns, such as ship date, Lot# and retest date.

I dont know if I am explaining myself properly, but thanks for any help.

Best regards,

Dee