CountIf Condition based on lookup in a list of values
Try
=COUNTIF(A:A,"red")
Or if you have A1 = red
=COUNTIF(A:A,A1)
If this post helps click Yes
---------------
Jacob Skaria
"Eric E" wrote:
I have a row with input data: cells with values of RED, GREEN, PINK, TAN.
I have a table/range (PRIMARY_COLORS) that includes RED, BLUE, GREEN.
I would like to count the number of valid primary colors are in the input
data row.
I cannot figure out how to include a conditional statement in the COUNTIF
function: i.e., COUNTIF the cell value is a MATCH in the PRIMARY_COLORS range.
Can this be done?
Thanks.
|