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