• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

COUNTIF Function will not count Blue

S

soul1974

New Member
Hi,

I used the Countif function to count the number of colours used in my project, but the Function will not count the blue colour for some reason.
=COUNTIF(ColourDepth;V$6)
The column "ColourDepth" is below. If I change the colour to grey, it counts. If I change it back to blue, nothing.

Black
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Blue
Grey
Grey
Grey
Grey
Grey
Grey
Grey
Grey
 
is the contents of the column have spaces before or after the names of colours
maybe its "Blue " rather than "blue"
what happens if you type BLUE into one of the cells - will it now count that 1

the sample with the issue would help , as the text above will just work OK when put into a spreadsheet
 
ETAF said:
is the contents of the column have spaces before or after the names of colours
maybe its "Blue " rather than "blue"
what happens if you type BLUE into one of the cells - will it now count that 1

the sample with the issue would help , as the text above will just work OK when put into a spreadsheet
Click to expand...
Hi ETAF,

Thanks, it seems that you were correct. There was a space after the Blue. I feel like such an idiot.
 
You must log in or register to reply here.
Back
Top