software

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=SUMIF(B:B,quot;Program Managerquot;,C:C)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Philipquot; gt; wrote in message
...
gt; Hi All,
gt;
gt; I have few data in multiple rows. I want to add up all the data in a
gt; specific number of cells which meet the criteira.
gt; Example
gt;
gt; 09000 Program Manager 20000
gt; 09800 Finance Manager 30000
gt; 09816 Program Manager 22000
gt;
gt; I want to extract in a seperate cell and the result for Program Manager
gt; should be like this.
gt;
gt; 09000 Program Manager 42000
gt;
gt; Please help me on this since I have a lot of reporting stuff to do.
gt;
gt;
gt; Thanks
gt;