View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Philip
 
Posts: n/a
Default Adding up data in multiple cells for a single criteria.

Hi All,

I have few data in multiple rows. I want to add up all the data in a
specific number of cells which meet the criteira.
Example

09000 Program Manager 20000
09800 Finance Manager 30000
09816 Program Manager 22000

I want to extract in a seperate cell and the result for Program Manager
should be like this.

09000 Program Manager 42000

Please help me on this since I have a lot of reporting stuff to do.


Thanks