Excel: Counting coloured cells


Hey all, Title says it all! Here's what I'm trying to do! Let me know if this can be done! TIA!! [CENTER]

G H I J K L M N O P
4 Blue or not
[CENTER]Sheet2[/CENTER] [/CENTER] If G3:K3 is blue count it. If qty is 3, G11=a number, 4=another number… OR if P3 and G3:K3 is blue and qty is >=2, G11=this number
G
11 Some Num
[CENTER]Sheet2[/CENTER]


This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of October 17, 2017.


For more resources for Microsoft Excel