Sumif
 

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

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

"Dee" wrote in message
...
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