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=1PO...OiATvQjbD2SSus
This is a sample of the Excel sheet. it is also attached below.
Summarily, In the Tab Suivi Conges I want to have the Total leave(L) days of Mary for the month of January only in cell G5 and for Feb in H5. if there is any cell having the letter L. With having just to drag the formula across and it referencing automatically and not having to change the data at each turn as I have to do this for over 50 staffs.
Hope my request is clearer?
Thanks for your time to review my problem and your suggested solution.
Try this:
=SUMPRODUCT(('Planning congés_2019'!$C$16:$C$40=$A4)*('Planning congés_2019'!$D$16:$D$40=$B4)*(TEXT('Planning congés_2019'!$L$15:$NL$15,"mmyyyy")=TEXT(G$3,"mmyyyy"))*('Planning congés_2019'!$L$16:$NL$40=$F4))
