COUNTIFS Error

[JNollett]

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

[#2 · Accepted 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.

[#3]

I hadn't realised this couldn't be done. Thanks for pointing it out. I appreciate it.

[#4]

@JNollett You are welcome!