Excel 2007 : How would I organize this data?

**CaptainGarry** · 01-06-2009, 04:58 PM

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, 10-14m, 14-23m, 23m+ and I need 2 sets of these values, one for each of the two boat types. 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. I attached the file, if its unclear what I'm asking I need to fill in the "port, trawler, seiners" sheet in the file. Thanks for your help!