General discussion

Locked

Excel 2007, calculating the sum of cells according to the cell colour

By anthonywhite ·
I have an excel spreadsheet listing various different staff skills e.g. designers, testers, coding etc on various projects in a verticle list with weeks horizontaly e.g. week begining 03 Feb 2008 and so on with the number of staff required each week and e.g. week beg 03 Feb 2008 we need 20 designers, 4 testers and 5 Coding staff, not all staff are required each week and not all staff require the same staff skills, for ease each staff discipline has been assigned a background colour is there any way of creating a formula that will calculate the total numbers of each staff skill, depending on the cell colour that highlights the staff skill?

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums