PDA

View Full Version : Only FOR JULY (07-01-18 to 07-31-18 ) as per formula available in cell



aligahk06
08-11-2018, 01:55 AM
Dear All,


I want value on Chart!G11 based on RM!L2:L152 only for the month of July i.e (07-01-18 to 07-31-18 ) as per formula available in cell


Attached sheet
Rgds,
aligahk06

p45cal
08-11-2018, 06:52 AM
In G11:
=SUMPRODUCT((RM!F2:F999=$D11)*((RM!H2:H999="WCLOSE")+(RM!H2:H999="COMP")+(RM!H2:H999="CLOSE"))*(MONTH(RM!L2:L999)=7)*(YEAR(RM!L2:L999)=2018))
copied down.