2. Enter all required arguments in an Excel function All Excel functions have one or more required arguments. Some functions also have optional arguments, which are enclosed in [square brackets] in the formula's syntax. A formula must contain all of the required arguments, otherwise Excel displa...
=SUMPRODUCT(--(C3:C100<=DATE(2015,12,31)), --(F3:F100="China"), --(G3:G100="DON"),--(I3:I100="M"), --(DATEDIF(E3:E100,TODAY(),"y")>=16), --(DATEDIF(E3:E100,TODAY(),"y")<=24)) You can also find useful information in this article: How to calculate age in Exc...
2. Enter all required arguments in an Excel function All Excel functions have one or more required arguments. Some functions also have optional arguments, which are enclosed in [square brackets] in the formula's syntax. A formula must contain all of the required arguments, otherwise Excel displa...