Hi,
I get this error went entering a formula
'The specified formula cannot be entered because it contains more values, references and/or names than are allowed in the current file format.'
I am entering a SUMPRODUCT formula with over 50 statements, example
=SUMPRODUCT(--(A1:A100="Fruit"),--(B1:B100="Oranges"))+SUMPRODUCT(--(A1:A100="Meat"),--(B1:B100="Beef"))
I get this error went entering a formula
'The specified formula cannot be entered because it contains more values, references and/or names than are allowed in the current file format.'
I am entering a SUMPRODUCT formula with over 50 statements, example
=SUMPRODUCT(--(A1:A100="Fruit"),--(B1:B100="Oranges"))+SUMPRODUCT(--(A1:A100="Meat"),--(B1:B100="Beef"))