Forum Discussion

Abdul H Khan's avatar
Abdul H Khan
Copper Contributor
Aug 11, 2018
Solved

Value on Chart!G11 based on RM!L2:L152 only for the month of July i.e (07-01-18 to 07-31-18 )

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  Chart!G11

 

Attached Sheet

excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Aug 11, 2018

    Hi Abdul,

     

    That could be

    =SUM(COUNTIFS(RM!F:F,D11,RM!H:H,{"WCLOSE","COMP","CLOSE"},RM!L:L,">="&DATE(2018,7,1),RM!L:L,"<="&EOMONTH(DATE(2018,7,1),0)))

    And better not to merge cells, format them as Center across selection.

    Attached

1 Reply

Sort By
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Aug 11, 2018

    Hi Abdul,

     

    That could be

    =SUM(COUNTIFS(RM!F:F,D11,RM!H:H,{"WCLOSE","COMP","CLOSE"},RM!L:L,">="&DATE(2018,7,1),RM!L:L,"<="&EOMONTH(DATE(2018,7,1),0)))

    And better not to merge cells, format them as Center across selection.

    Attached

Resources