Help with Countifs

[Janie]

Hi,
I am trying to create a count formula that is based on another cell.

So in column A I have "Suzy"
Column E has a date 1/1/2018

What I am trying to accomplish is, if column A says Suzy, then count column E

The criteria really is: only count column E if the criteria is met in column A.

Hope someone can follow what I'm saying....

Thanks

[63falcondude]

Why not simply count the number of instances where column A says "Suzy"?

That would be this:

=COUNTIF(A:A,"Suzy")

[Janie]

Thanks for replying. I can't use how many times it says Suzy, because sometimes there is no date in Column E - so if the name says Suzy in Column A, but there isn't any date in Column E, that would not be included in the count.

Col A Col E
Suzy blank = 0
Suzy 10/2/2018 = 1

Hope this clarifies.

[Sam Capricci]

then how about something like =COUNTIFS(E2:E2000,"<>",A2:A2000,"suzy")