Try pivot tables instead

www.cpearson.com/excel/pivots.htm