Tocogroup
asked on
How do I create an Excel 2003 array formula using date criteria ?
Dear All,
I have created a multiple criteria array formula to count the number of cells with a particular date in one range and a value in another range. Is there something about dates in array formulas that I should know, because it doesn't seem to recognise the criteria ?
Appreciate your help in anticipation.
Please find the worksheet attached. Date-criteria-enquiry.xls
I have created a multiple criteria array formula to count the number of cells with a particular date in one range and a value in another range. Is there something about dates in array formulas that I should know, because it doesn't seem to recognise the criteria ?
Appreciate your help in anticipation.
Please find the worksheet attached. Date-criteria-enquiry.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry, typo. Should be:
{=COUNT(IF(B4:B15=VALUE("0 3/09/2010" ),IF(C4:C1 5>100,C4:C 15)))}
{=COUNT(IF(B4:B15=VALUE("0
ASKER
Thanks guys. I like the non-array formula version and will start using the DATE function in my formulas in future.
={COUNT(IF(B4:B15=VALUE("0