Countif question

Hi everyone


this is probably not difficult for most of you but for me...

So, I have this column with ID values and some of them are recurrent. When the ID is not available I insert "N/A".

How do I change this formula to disregard the value "N/A"?


=COUNTIF(D:D,D2)

Thanks

If you can upload the document I would be happy to take a look for you

Thank you! Just can't find the option for attachments...

At the bottom of your message editor click 'Go Advanced' and then scroll down and click 'Manage Attachments'

I'm getting this message: You are not allowed to post any kinds of links, images or videos until you post a few times.

So...

Thanks, I'll try it!!!

That will work just don't forget to put "=" at the beginning:

Please Login or Register  to view this content.

Also, don't forget to hit the star for any positive contribution ;-)

ok!!

I'm out of the office but will try it asap.

thx Davo I didnt see i omitted the =

Finally managed a few moments to come here: worked like a charm!
thanks again!