COUNTIFS doesn't work properly Correction needed or alternative Function

[Alysiin P]

Greetings Excel Wizard,

I am working on a sheet and I want to use the COUNTIFS function on another to obtain data from another TAB

The criteria I want is Data of a particular name, position and Month to count the number of letter L are in the month.

I tried doing this on the Tab "Suivi congés_RR 2019" but I got a #VALUE! as a solution. Not what I want.

https://drive.google.com/open?id=1POCBS8l9pI-27zO44VOiATvQjbD2SSus

This is a sample of the Excel sheet.

Thanks for your time to review my problem.

You just save my brain from try to guess what I was doing wrong.

 

[DanteAmor]

Check the dates on the "Planning congés_2019" sheet, in row 15, after March your formula is not correct.


Try this one:


=SUMPRODUCT(('Planning congés_2019'!$C$16:$C$40=A8)*('Planning congés_2019'!$D$16:$D$40=B8)*(MONTH('Planning congés_2019'!$M$15:$NL$15)=MONTH(G$3))*('Planning congés_2019'!$M$16:$NL$40="L"))