Forum Discussion

DSGN1's avatar
DSGN1
Copper Contributor
Mar 29, 2019
Solved

SUMIF values in date range not working

Hi there, I've gotten this to work before but it's not now. I'm trying to total the commissions for any sales made within a date range. For some reason, though I've entered the formula exactly how I...
  • SergeiBaklan's avatar
    Mar 29, 2019

    DSGN1 ,

    =SUMIFS(D4:D60,B4:B60,">="&H7,D4:D60,"<="&I7)

    it shall be B column for the second criteria

Resources