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

B

Beena K

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
 
S

Sheeloo

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top