Forum Discussion

Chris Sanders's avatar
Chris Sanders
Copper Contributor
May 17, 2018
Solved

SUMIF a date falls between to dates

Hi there,   I have a large data set and would like to sum a column if a certain date falls between two others, here is a sample of the data set; A                    B                   C        D...
Formulas & Functions
Need Help
  • Detlef_Lewin's avatar
    Detlef_Lewin
    May 17, 2018
    =SUMIFS(Tabelle1!$D$1:$D$4,Tabelle1!$A$1:$A$4,"<="&A2,Tabelle1!$B$1:$B$4,">="&A2)
Belinda Lee's avatar
Belinda Lee
Copper Contributor
May 17, 2018

I have tried SUMIF.

And it turns out Zero. I didn't know why, either. Sorry.

Resources