Forum Discussion
Convert Array formula
Hi there, I'm trying to insert a formula (COUNTIFS) from a table. I've done this countless times with no issue. The array looks different when I try to get the criteria from the table. It seems ...
See the example inserted in the Excel file.
=SUMPRODUCT(--(EXACT(J8:J12,D1)))
for the Sheet "Form1"
=SUMPRODUCT(--(EXACT(Form1!E2:E6,D1)))
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)