This is my data:

cat blue 2005
dog red 2005
cat <empty> 2005
dog yellow 2005
canary <empty> <empty>
dog <empty> 2004

The animal column is range named "animal." The years are dates (2/2/2005) custom formatted to display as "yyyy". That implies they're numeric, and should register to the count() function.

I need a count of the rows where a dog visited in 2005. I have some examples that translate to:
=COUNT(IF((animal="dog")*(visit>=("1/1/2005"))*(visit<("1/1/2006")),visit))

and:
=COUNT(IF(AND(animal="dog",visit>=("1/1/2005"),visit<("1/1/2006")),1))

These return 0; some variations return 1. Obviously there were 2 dog visits in 2005, but I'm having problems figuring out the syntax. Can anyone help?

Thanks in advance. Apologies for duplicate posts, my previous thread #1722448 seems to have vanished into thin air.