Count Question

[cionnaith]

Good day folks!

I have another question about counting in cells.

I need to count across four adjacent cells (e.g. A1:A4) where each of these cells can have one of three nominal entries (i.e. green, yellow, or red). I need an entry of green to be equal to 2, an entry of yellow equal to 1 and an entry of red equal to 0. Once that is done, I need the sum of those values assigned divided my the maximum possible across the four cells...in this case 8.

Hope this makes sense...

Thanks in advance!

 

[cionnaith]

Would you mind showing how to do that last computation you gave me to these that just calculate percentages of each of the nominal types? I was messing around by trying to add what you included in that last computation to replace the /4, but am clearly doing something wrong

Here is what you gave me for the first one "green"

=IF(COUNTA(A1:A4),COUNTIF(A1:A4,E1)/4,"")


Thanks again. Hopefully, I will be leaving you alone after this one :P

 

[T. Valko]

Would you mind showing how to do that last computation you gave me to these that just calculate percentages of each of the nominal types? I was messing around by trying to add what you included in that last computation to replace the /4, but am clearly doing something wrong

Here is what you gave me for the first one "green"

=IF(COUNTA(A1:A4),COUNTIF(A1:A4,E1)/4,"")


Thanks again. Hopefully, I will be leaving you alone after this one :P

If you want the percentage of non-empty cells that contain "this color"...

Maybe this...

=IF(COUNTA(A1:A4),COUNTIF(A1:A4,E1)/COUNTA(A1:A4),"")

 

[cionnaith]

If you want the percentage of non-empty cells that contain "this color"...

Maybe this...

=IF(COUNTA(A1:A4),COUNTIF(A1:A4,E1)/COUNTA(A1:A4),"")

You are an excellent person!!! Thanks again!!!

 

[T. Valko]

You are an excellent person!!! Thanks again!!!

You're welcome. Thanks for the feedback!