View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Markl9869 Markl9869 is offline
external usenet poster
 
Posts: 3
Default Summing data on duplicate records?

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.