Hi,

I need to:

Count A1, if D2 equals E2, and A2 equals 101

PIC.jpg

'=COUNTIFS(A1,"D1=D2",A1,"101")' does not work.

Could someone help me please?

Thank you!

Kevin