Dec 16 2021 11:28 AM
Hi
I have a frustrating issue with COUNTIFS. If I enter it with a single criterion on two different columns, it works, but if I have the two working criteria in the same formula it fails with #VALUE.
=COUNTIFS(TableSFData[[Employee 1]:[Employee 4]],'Individual Productivity'!A5)
Returns 70
=COUNTIFS(TableSFData[Date],">" & I7)
Returns 2363
=COUNTIFS(TableSFData[[Employee 1]:[Employee 4]],'Individual Productivity'!A5,TableSFData[Date],">" & I7)
Returns #VALUE
Does anyone know why this is?
Thanks in advance
Dec 16 2021 11:38 AM
Solution@JNollett The dimensions of the arrays should be the same. In your case you have a 4-column by all rows and a 1-column but all rows. Hence #VALUE.
Dec 16 2021 11:40 AM
Dec 16 2021 11:38 AM
Solution@JNollett The dimensions of the arrays should be the same. In your case you have a 4-column by all rows and a 1-column but all rows. Hence #VALUE.