This could be a job for a pivot table. Here's a brief intro on my site,
written by Debra Dalgleish:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
and some links, which wouldn't have been included if they weren't helpful:
http://peltiertech.com/Excel/Pivots/pivotlinks.htm
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
foxgguy2005 wrote:
you know, on second thought, i know this is charting, worksheet
functions is my next stop.
Anyway, i thought about it, and instead of sorting the list,
are there cells i could create a functio in to sum the total numbers of
the rows that have a certain type of lumber...
like, sum of rows in colum "X" if column "y" = sill ???
and have it only add the rows with certain label.
Thaks guys!