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...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Mar 29, 2019

    DSGN1 ,

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

    it shall be B column for the second criteria

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 29, 2019

DSGN1 ,

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

it shall be B column for the second criteria

DSGN1's avatar
DSGN1
Copper Contributor
Mar 29, 2019
What would be the formula if I wanted it to sum that date range 3D, across all sheets in the workbook?

Resources