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
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
In G11:
=SUMPRODUCT((RM!F2:F999=$D11)*((RM!H2:H999="WCLOSE")+(RM!H2:H999="COMP")+(R M!H2:H999="CLOSE"))*(MONTH(RM!L2:L999)=7)*(YEAR(RM!L2:L999)=2018))
copied down.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.