none
SumIfs with time criteria RRS feed

  • Pergunta

  • Hi there,

    I'm look for a VBA Excel code to make a SumIfs with time criteria.

    I'm using a range of cells with 258700 rows and I'm trying to do like this.

    Sheets("CALC").Cells(LShClc, 24) = WorksheetFunction.SumIfs(MyRangeDuration, MyRangeMachine, Maq, MyRangeCode, 200, MyRangeBTime, (">=" & "05:50:00" and "<=" & 14:10:00"))

    It's not recognize the times when I put ">=" signal, only runs if I put "=".

    Please help me to solve this code.

    domingo, 16 de julho de 2017 00:26