Based on data in previous column - sum of values in next column
 

Hi,
In my xls file
Col A1 to Col A10 = text data ( Project Types )
Col B1 to Col B10 = Numbers (Resource count in that project)
Col C1 to Col C3 = Need formula which calculates no of resources per project
type.
Project Name Project Type Resource count Col C
Project 1 Development 9 in this col need
Project 2 Maintenance 2 count of resources
Project 3 Testing 2 in Dev
projects
Project 4 Development 4 then
maintenance etc
Project 5 Development 5


Thanks in advance
Cordially
Beena K

Based on data in previous column - sum of values in next column
 

With project type in Col B and resource count in Col C
this will give you the sum
=SUMPRODUCT(--(B1:B100="Dev"),C1:C100)

You can replace "Dev" with reference to the cell (say D1) containing the
desired project type...
like
=SUMPRODUCT(--(B1:B100=D1),C1:C100)
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Beena K" wrote:

Hi,
In my xls file
Col A1 to Col A10 = text data ( Project Types )
Col B1 to Col B10 = Numbers (Resource count in that project)
Col C1 to Col C3 = Need formula which calculates no of resources per project
type.
Project Name Project Type Resource count Col C
Project 1 Development 9 in this col need
Project 2 Maintenance 2 count of resources
Project 3 Testing 2 in Dev
projects
Project 4 Development 4 then
maintenance etc
Project 5 Development 5


Thanks in advance
Cordially
Beena K