Adding up data in multiple cells for a single criteria.

P

Philip

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
 
B

Bob Phillips

=SUMIF(B:B,"Program Manager",C:C)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top