How do I organize my data in this way

I'm doing this database for spanish boats. The Columns are Boat name, Port, Boat type (trawler or seiner) and boat length. I have all this data entered but I need to organize it in the following way: I need to list for each port how many boats it has within certain length values, ie 10-14m, 14-23m, etc. I can't figure out how to get it to organize it like this!! I tried putting on a filter for the values I want and then using the subtotal thing but when I use it it randomly removes certain ports from the list. Doing that worked perfectly for counting the boat totals for each port, and the totals for each type of boat in each port but as soon as I start filtering by length it goes wacky and decides to not display many of the ports. Please help!

Sorry here's the file, I need to fill in the "port, trawler, seiners" tab. Thanks!

At first sight a Pivot Table might be what you want, but I'm not yet familiar with the 2007 version of Pivot Tables

I think this should work for you.

That's really close, is there a way to get it to display zero values instead of just omitting them?

Originally Posted by ExcelFed

I think this should work for you.

Not sure if its displaying correctly its showing vessel names for each port and all the ports aren't displayed. The vessel names are unimportant.

Alright I will ask in that forum. Much thanks for the help!

Originally Posted by Ron Coderre

Have you considered using a Pivot Table to summarize the data?

Using your posted workbook....
I created a lookup table to translate boat lengths to length categories.
I added a column of formulas that reference that lookup table.
Then, I created a Pivot Table using those categories

I attached the edited file to this post (I had to use the XLSX file converter
because I have Excel 2003...Hopefully, the Pivot Table will convert properly)

Does that give you something to work with?

I switched to office 2003 can you send me the 2003 file

Originally Posted by Ron Coderre

Have you considered using a Pivot Table to summarize the data?

Using your posted workbook....
I created a lookup table to translate boat lengths to length categories.
I added a column of formulas that reference that lookup table.
Then, I created a Pivot Table using those categories

I attached the edited file to this post (I had to use the XLSX file converter
because I have Excel 2003...Hopefully, the Pivot Table will convert properly)

Does that give you something to work with?

Ok I got it finished now. Can you explain further how you made the lookup table? How do you define the categories? I'm pretty sure the functions are the same in both versions