lizardmixture
New Member
- Joined
- Dec 8, 2010
- Messages
- 6
I'm trying to do a resource allocation sheet. Basically I have months going across the top and an "x" in each cell for the months that the project is active. I want to count the "x"es and then multiply by the number of resources used (in a different column). Seems like it wouldnt be hard but i can't seem to figure it out. Thanks!
Hope you can see this. The resources sum column is E. At the bottom you'll see the conditional formatting I'm trying to use, red, green and yellow. I'm trying to say "if there is an "o" in the column, then add the resource number for that row to the total for that column (month).
