Array Formulas with multiple arguments
Posted by Julie Braford on September 02, 2001 5:14 PM
Is there a limit to the number of arguments that can be used in an array formula? I am not able to get a sum,if & and statment as an array to work. It will accept it with an additional (uneccesary) set of parentheses, but it does not function properly. Here is the exact array formula:
I am trying to count the number of results within a range that fall within a range (can't use contstant values), is there another way to do?
Thank you for your help.