Counting up the text values

[Cmorgan]

Evening,

Any help would be greatfully appreciated:

I'm using this formula:

COUNTIF(H:H,B13)

This allows me to count up how many times the value of B13 is in column H. What I would like to do is count up all the other values in column H which aren't B13 - there's anything up to 25 different values this could be.

Any ideas please?

Many thanks

[arthurbr]

Try =COUNTIF(H:H,"<>"&B13)

[Cmorgan]

Thanks for this, but there's something wrong with this as it comes back with a figure of over a million, when it should be nearer 45, any ideas?

Thanks for your help.

[arthurbr]

That is because you have used H:H which selects the entire column.

Maybe use the real length of the range like H1:H500 ?

Or if you have no blanks in your range =COUNTIF(H:H,"<>"&B13)-countblank(H:H)

[Cmorgan]

That's perfect now when I put the range in, many thanks.

[arthurbr]

Glad to help and thanks for the rep