Is There An Aggregate Function in Excel?

[barbara]

I need to aggregate my spreadsheet by items such as
industry segments, geographies, etc. All the variations
are in a single field. Is there an aggregate function in
Excel that I am overlooking?

Thanks in advance.

 

[Ken Wright]

Take a look at Pivot Tables - A good intro to be had from Debra Dalgleish at the following link:-

http://www.geocities.com/jonpeltier/Excel/Pivots/pivotstart.htm