Hi and thanks in advance,
I have a shared workbook with some SUMPRODUCT formulas, in the 'Finalised' column of my Stats table, which Excel is treating as array formulas (didn't know SUMPRODUCT was array) that count rows in my 'Data' sheet where the date in column N matchs the month and year in my Stats table. I would like to covert these formulas to non-array since I am unable to copy the values returned by the formulas without getting the error message: Cannot copy or move array entered formulas or data tables in a shared workbook.
=SUMPRODUCT(--(MONTH(Data!$N$2:$N$1000)=F44),--(YEAR(Data!$N$2:$N$1000)=H44))
Cheers
Deutz
I have a shared workbook with some SUMPRODUCT formulas, in the 'Finalised' column of my Stats table, which Excel is treating as array formulas (didn't know SUMPRODUCT was array) that count rows in my 'Data' sheet where the date in column N matchs the month and year in my Stats table. I would like to covert these formulas to non-array since I am unable to copy the values returned by the formulas without getting the error message: Cannot copy or move array entered formulas or data tables in a shared workbook.
=SUMPRODUCT(--(MONTH(Data!$N$2:$N$1000)=F44),--(YEAR(Data!$N$2:$N$1000)=H44))
Cheers
Deutz