SOLVED

COUNTIFS Error

Occasional Contributor

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

3 Replies
best response confirmed by JNollett (Occasional Contributor)
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.

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

@JNollett You are welcome!