Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I sum.....
I have set up the column to be r=color RED, g =color GREEN, y = color YELLOW.
Basically Red = no started, Y = working, and Green = completed. I want to sum all the field to determine percentage complete. So if all Green then 100% complete. If I have 10 fields and 5 are Green and 5 are either yellow or red then total is 50%. How do I create that formula? |
#2
|
|||
|
|||
=COUNTIF(A1:A10,"g")/COUNTA(A1:A10)
format as percentage Regards, Peo Sjoblom "Mark" wrote: I have set up the column to be r=color RED, g =color GREEN, y = color YELLOW. Basically Red = no started, Y = working, and Green = completed. I want to sum all the field to determine percentage complete. So if all Green then 100% complete. If I have 10 fields and 5 are Green and 5 are either yellow or red then total is 50%. How do I create that formula? |
#3
|
|||
|
|||
Peo -
Thanks, that is exaclty what I needed. Can you help me take it a step further: If I am less than 50% show red, between 50-99% show yellow and 100% show green for the summed field. Thanks! Mark "Peo Sjoblom" wrote: =COUNTIF(A1:A10,"g")/COUNTA(A1:A10) format as percentage Regards, Peo Sjoblom "Mark" wrote: I have set up the column to be r=color RED, g =color GREEN, y = color YELLOW. Basically Red = no started, Y = working, and Green = completed. I want to sum all the field to determine percentage complete. So if all Green then 100% complete. If I have 10 fields and 5 are Green and 5 are either yellow or red then total is 50%. How do I create that formula? |
#4
|
|||
|
|||
Take a look at Format|Conditional formatting.
You'll see that you can specify up to 3 formats (which sounds perfect for you!). Mark wrote: Peo - Thanks, that is exaclty what I needed. Can you help me take it a step further: If I am less than 50% show red, between 50-99% show yellow and 100% show green for the summed field. Thanks! Mark "Peo Sjoblom" wrote: =COUNTIF(A1:A10,"g")/COUNTA(A1:A10) format as percentage Regards, Peo Sjoblom "Mark" wrote: I have set up the column to be r=color RED, g =color GREEN, y = color YELLOW. Basically Red = no started, Y = working, and Green = completed. I want to sum all the field to determine percentage complete. So if all Green then 100% complete. If I have 10 fields and 5 are Green and 5 are either yellow or red then total is 50%. How do I create that formula? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|