Use a Pivot Table:
http://www.cpearson.com/excel/pivots.htm

http://www.contextures.com/xlPivot02.html

Regards,
Ryan---

--
RyGuy


"Markl9869" wrote:

I have a worksheet that has the following column headers:
Organization
Project#
Cost
Cost Center
Month Posted

where each row lists the cost a project from a specific organization has
charged to a particular cost center (a chargeback data set if you will).

I would like the cost centers listed on the lefthand side and then, based on
a drop down selection of organization, summarize by month (listed across the
top) the charges made to each cost center.