View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon in the U&L Jon in the U&L is offline
external usenet poster
 
Posts: 1
Default Consolidating and totaling rows into single row

I have an Excel 2003 spreadsheet with Position Title, Location, Pay Plan,
Position Series, Position Grade, and FTEs. I want to organize this data by
Position Title, then Location, then Grade, and finally FTEs.

For example, I have multiple rows of Human Resources Specialist in different
locations, in different grades each with a FTE of 1. I'd like to consolidate
each row of Human Resources Specialist in the same location in the same grade
and have the row display the total number of FTEs for that title in that
grade at that location.

Thanks in advance for your help!