Trying to do the following:
IF:
Condition 1: $J$3:$J$5000=1
Condition 2: $C$3:$C$5000="Base"
Condition 3: (TEXT($AF$3:$AF$5000,"mmmyyyy")=TEXT(NOW()-DAY(NOW()),"mmmyyyy"))
This third condition makes the formula only look at rows where column AF has a date value that falls during the prior month, whatever that may be relative to the current month.
THEN:
Calculate quotient where count of all values in column AV3:AV5000 is the denominator, and count of values in column AV3:AV5000 where "Under" is the value, is the numerator.
While I have Office 2010 I would prefer the answer to be in array format so folks using 2002 Excel can use this tool.
IF:
Condition 1: $J$3:$J$5000=1
Condition 2: $C$3:$C$5000="Base"
Condition 3: (TEXT($AF$3:$AF$5000,"mmmyyyy")=TEXT(NOW()-DAY(NOW()),"mmmyyyy"))
This third condition makes the formula only look at rows where column AF has a date value that falls during the prior month, whatever that may be relative to the current month.
THEN:
Calculate quotient where count of all values in column AV3:AV5000 is the denominator, and count of values in column AV3:AV5000 where "Under" is the value, is the numerator.
While I have Office 2010 I would prefer the answer to be in array format so folks using 2002 Excel can use this tool.