Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count help please
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count help please
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count help please
Hi
Try this: =SUMPRODUCT((Candace!F3:F590 <A3)*1,(Candace!C3:C590="Inbound")*1) Regards, Per "LiveUser" skrev i meddelelsen ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count help please
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" 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count help please
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" wrote in message ... 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" 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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count help please
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |