It works. I had some issue with some code I had in the worksheet. Thank you!

"PCLIVE" wrote:

Try this:

=SUMPRODUCT(--(Candace!F3:F590=A3),--(Candace!C3:C590="Inbound"))

Note - Your formula was counting everything that did not match the date in
A3. I'm assuming you want to count every "Inbound" call indicated by column
C that matches a specific date (A3) in column F of Sheet Candace.

Does that help?
Paul

--

"LiveUser" wrote in message
...
This is what I have:

=COUNT(Candace!F3:F590,"<A3")

What I need is for cell B3 to count the total number of a certain date
(A3).

To do this, the Date on the Candace! sheet must match the date in A3.

(And) But, I also need it to only count if column C on Candace! is
"Inbound"

Thank you.