Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF Function issue
I need to make a count if function which will count the cell in a column if
the date in that column meets the following condition TODAY()-A190 A1 in this formula represents the the Cell being referenced in a column of 60 dates I need to know how many of those dates are more than 90 days old. Thanks in advance for any help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF Function issue
more than 90 days old.
Try this: =SUMPRODUCT(--(A1:A60<TODAY()-90)) -- Biff Microsoft Excel MVP "Gweduc" wrote in message ... I need to make a count if function which will count the cell in a column if the date in that column meets the following condition TODAY()-A190 A1 in this formula represents the the Cell being referenced in a column of 60 dates I need to know how many of those dates are more than 90 days old. Thanks in advance for any help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF Function issue
=SUMPRODUCT(--(A1:A60<TODAY()-90))
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Gweduc" wrote in message ... I need to make a count if function which will count the cell in a column if the date in that column meets the following condition TODAY()-A190 A1 in this formula represents the the Cell being referenced in a column of 60 dates I need to know how many of those dates are more than 90 days old. Thanks in advance for any help |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF Function issue
=SUMPRODUCT(--(A1:A60<TODAY()-90),--(A1:A60<""))
"Gweduc" wrote: I need to make a count if function which will count the cell in a column if the date in that column meets the following condition TODAY()-A190 A1 in this formula represents the the Cell being referenced in a column of 60 dates I need to know how many of those dates are more than 90 days old. Thanks in advance for any help |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF Function issue
Thanks for your help with this, it worked very well.
Sid "T. Valko" wrote: more than 90 days old. Try this: =SUMPRODUCT(--(A1:A60<TODAY()-90)) -- Biff Microsoft Excel MVP "Gweduc" wrote in message ... I need to make a count if function which will count the cell in a column if the date in that column meets the following condition TODAY()-A190 A1 in this formula represents the the Cell being referenced in a column of 60 dates I need to know how many of those dates are more than 90 days old. Thanks in advance for any help |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF Function issue
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Gweduc" wrote in message ... Thanks for your help with this, it worked very well. Sid "T. Valko" wrote: more than 90 days old. Try this: =SUMPRODUCT(--(A1:A60<TODAY()-90)) -- Biff Microsoft Excel MVP "Gweduc" wrote in message ... I need to make a count if function which will count the cell in a column if the date in that column meets the following condition TODAY()-A190 A1 in this formula represents the the Cell being referenced in a column of 60 dates I need to know how many of those dates are more than 90 days old. Thanks in advance for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif issue | Excel Worksheet Functions | |||
Weeknum function issue | Excel Worksheet Functions | |||
SumProduct CountIF issue | Excel Worksheet Functions | |||
YEAR function issue | Excel Worksheet Functions | |||
Date function/Text issue | Excel Worksheet Functions |