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?

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,

bgoree09 said:

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,

Click to expand...

Awesome.. thanks... perfect.

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

You're very welcome.