Sumif

[Dee]

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 don’t know if I am explaining myself properly, but thanks for any help.

Best regards,

Dee

 

[Biff]

Hi!

Assume column B has the checkboxes for 1 mg vials and column C has the
checkboxes for 10 mg vials.

Since you said:

I put a checkbox in each cell and linked it to the cell.

To count all the checboxes that are check in column B for 1 mg vials:

=COUNTIF(B:B,TRUE)

Do the same for column C and the 10 mg vials.

Biff