Complicated counting

[marek256]

Hey Guys, here at the company, we used to release shipping containers according to references.
We have a simple sheet where we used to write released containers.
The problem is that there are really a lot of references and we need to keep track how many containers we need to release and because of that we need to count it manually.
Because of that I would like to ask if there would be a function to count it. I know that there is a counta, countif function but there are an empty lines which should not count.
Basically I need, how many 20´DC containers left to release, how many 40´DC containers left to release and how many 40´HC containers left to release.
I am attaching a tiny part of the list to see what I am talking about.
Thanks in advance

http://www61.zippyshare.com/v/bkFWfw53/file.html

 

[DHayes]

Hi,
Please collect the file from my dropbox.
Dropbox - Book5.xlsx

 

[marek256]

Hey buddy,
thanks, the formula works in your file but unfortunately I have expressed myself obviously wrong because this counts number of released containers and not the opposite, how many remains. I think I explained it wrong, I need the counter for remaining containers in total in those 3 categories. I add in the next column the right numbers. I think you should be able to fix it because you are close. I got lost in the formula immediately

http://www104.zippyshare.com/v/kiN2XmB8/file.html

 

[DHayes]

Hi Marek,
Sorry for the delay have been away. The formula below works as requested.

=SUMIF($D$2:$F$26,G1,$E$2:$E$26)-COUNTIFS($D$2:$D$26,G1,$F$2:$F$26,"<>"&"")

 

[marek256]

Hello,
you are my superhero! It works amazingly! You have helped me a lot, thanks you a million!
I am going to apply it into entire sheet.
Thanks again!

 

[DHayes]

You are welcome