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.

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" <(E-Mail Removed)> wrote in message
news:3B62BD61-EB01-489A-BD6F-(E-Mail Removed)...
> 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.

Hi

Try this:

=SUMPRODUCT((Candace!F3:F590 <>A3)*1,(Candace!C3:C590="Inbound")*1)

Regards,
Per

"LiveUser" <(E-Mail Removed)> skrev i meddelelsen
news:3B62BD61-EB01-489A-BD6F-(E-Mail Removed)...
> 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.

For some reason it is returning zero even though I have 4...

"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" <(E-Mail Removed)> wrote in message
> news:3B62BD61-EB01-489A-BD6F-(E-Mail Removed)...
> > 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.
>
>
>

Are the values in column F actually Dates? Try formatting one of the cells
in column F to General. If the date in that cell were to be 6/27/2008, then
the when changed to General, it should be displayed as 39626. If that
doesn't change when you change to General, then the values are not actual
dates.

You might try:

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

Another possibility is that there may be either leading or trailing spaces
in column C. Example " Inbound" or "Inbound ".

HTH,
Paul

--

"LiveUser" <(E-Mail Removed)> wrote in message
news:9B75C1A8-55C2-42F6-86D9-(E-Mail Removed)...
> For some reason it is returning zero even though I have 4...
>
> "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" <(E-Mail Removed)> wrote in message
>> news:3B62BD61-EB01-489A-BD6F-(E-Mail Removed)...
>> > 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.
>>
>>
>>

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" <(E-Mail Removed)> wrote in message
> news:3B62BD61-EB01-489A-BD6F-(E-Mail Removed)...
> > 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.
>
>
>