Count function with exclusions

wow, very quick reply. And it works excellently too.

Million thanks Carim.

D ;-)

Thanks for the feedback

Carim

Carim,

I've realised soemthing. Its not entirely wokring properly now. If i use your command, i get a value. But if i go to the other worksheet and add a "valid" number, the sum on Sheet 1 doesn't increment. It was working b4, but its not adding to the count if i add more entries on Sheet 2. Why would this be, if before it was working fine?

Please advise.

ok, what seems to be happening is that if i enter a numerical value, the COUNTIF figures increases. Thats good. However, if i add any sort of word (text) even if nothing near the word "Free", the counter remains still. I thought the code you gave me would only filter out the keywird Free?

Plase advise.

Thanks

D

Hi again,

It all depends on the nature of your inputs in your cells ...
Originally I understood you wanted to excluded cells containing the word Free ...

Now, if I understand correctly your input cells can themselves contain many words including the word Free ... is that right ... ?

Best solution, as always, is to post a zipped copy of your worksheet for a precise answer ...

HTH
Carim

precisely. the column will contain various words, but mainly numbers. I only want to filter out the word FREE.

In any case, what i've realised is that the count function fails me when the range goes beyond 1500 cells. Is that normal. For example, my range is A2:A2000.

no idea

Hi again,

Countif() will not fail because of the number of rows ...
But it will fail with cells containing spaces, blanks, ...

HTH
Carim