count formula

Edit Kalb

I want a formula to count the number of cells in a column that are red, green, blue or yellow. The only value to not include in the count is if it's blank

Paul Newcome

To count for "not blank", you would use something along the lines of...

=COUNTIFS([Column Name];[Column Name], @cell <> "")

Paul Newcome

To count for "not blank", you would use something along the lines of...

=COUNTIFS([Column Name];[Column Name], @cell <> "")