# Thread: Need help with a formula to calculcate a count with various variables

1. ## Need help with a formula to calculcate a count with various variables

OK. i have an excel sheet that we use to count & control the number of containers on the premises. I would like a formula that can breakdown the number of containers, per size, condition and status...automatically and show this on a second sheet of the workbook.

Container -- there exists 8 sizes ( 20 std, 40std, 40hc, 45hc, 40 ref, 20 gaz, 40 gaz, 45 gaz) - Column G

Each container is identified into a condition identified as ( A, B, C, D). - Column J

Lastly each container can be Empty, Loaded, or Assigned (Vacio, Lleno, o Asignado) - Column D ( I understand that right now on the sheet there is some information that is not within these 3 selections--- i will correct this with the data validation-- should only be these 3 data inputs

Right now while all the information is in the sheet--- right now, we filter per container.. and then manually count because we have not inputted a formula for this yet.

Each row is a container-- once the container is loaded or dispatched its removed from the sheet. The information on the sheet will never exceed row 250

The idea is to give the user an accurate count automatically. On the second sheet i was thinking of putting the info for Empty, Loaded and Asignado.... as of right now.. i only put the table for the Vacio... or Empty.

Can someone help?

2. Good afternoon,

Please see the attached file. Since there is an extra criteria I had to use 3 tables instead of 1. I suppose this could be condensed into 1 table with 3 sections. Either way, I think this is what you were looking for. If I'm off just let me know.

Best of luck,

3. Originally Posted by bgoree09
Good afternoon,

Please see the attached file. Since there is an extra criteria I had to use 3 tables instead of 1. I suppose this could be condensed into 1 table with 3 sections. Either way, I think this is what you were looking for. If I'm off just let me know.

Best of luck,
Awesome.. thanks... perfect.

now im just going through your formula to learn.... thank you very much...

4. You're very welcome.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•