| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIF Q
I have dates listed in Column A7:A377. How can I incorporate this
formula =COUNTIF(C7:C377,"=0") to count only if the Dates in A7:A377 are less than TODAY() Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CountIF Q
=SUMPRODUCT((A7:A377<TODAY())*(C7:C377=0))
-- David Biddulph "Sean" wrote in message oups.com... I have dates listed in Column A7:A377. How can I incorporate this formula =COUNTIF(C7:C377,"=0") to count only if the Dates in A7:A377 are less than TODAY() Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CountIF Q
Try,
=SUMPRODUCT((A7:A377<TODAY())*(C7:C377=0)) Mike "Sean" wrote: I have dates listed in Column A7:A377. How can I incorporate this formula =COUNTIF(C7:C377,"=0") to count only if the Dates in A7:A377 are less than TODAY() Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CountIF Q
On Sep 19, 8:58 am, Mike H wrote:
Try, =SUMPRODUCT((A7:A377<TODAY())*(C7:C377=0)) Mike "Sean" wrote: I have dates listed in Column A7:A377. How can I incorporate this formula =COUNTIF(C7:C377,"=0") to count only if the Dates in A7:A377 are less than TODAY() Thanks- Hide quoted text - - Show quoted text - Thanks Guys |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CountIF Q
On Sep 19, 8:58 am, Mike H wrote:
Try, =SUMPRODUCT((A7:A377<TODAY())*(C7:C377=0)) Mike "Sean" wrote: I have dates listed in Column A7:A377. How can I incorporate this formula =COUNTIF(C7:C377,"=0") to count only if the Dates in A7:A377 are less than TODAY() Thanks- Hide quoted text - - Show quoted text - Slight twist on above, how could I count If (C7:C377,"<0") AND (C7:C377,"4")) In other words Count times values are between 1-4? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CountIF Q
On Sep 19, 9:07 am, Sean wrote:
On Sep 19, 8:58 am, Mike H wrote: Try, =SUMPRODUCT((A7:A377<TODAY())*(C7:C377=0)) Mike "Sean" wrote: I have dates listed in Column A7:A377. How can I incorporate this formula =COUNTIF(C7:C377,"=0") to count only if the Dates in A7:A377 are less than TODAY() Thanks- Hide quoted text - - Show quoted text - Slight twist on above, how could I count If (C7:C377,"<0") AND (C7:C377,"4")) In other words Count times values are between 1-4?- Hide quoted text - - Show quoted text - Worked it =SUMPRODUCT(($A7:$A377<TODAY())*(C7:C3770)*(C7:C3 77<4)) |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CountIF Q
try:
=SUMPRODUCT((A1:A10<TODAY())*(B1:B10=0)) or {=sum((A1:A10<TODAY())*(B1:B10=0))} HTH Regards Sebation.g "Sean" groups.com... I have dates listed in Column A7:A377. How can I incorporate this formula =COUNTIF(C7:C377,"=0") to count only if the Dates in A7:A377 are less than TODAY() Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
| edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
| Countif | Excel Discussion (Misc queries) | |||
| COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Linear Mode
