Forum Discussion
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...
=SUMIFS(Tabelle1!$D$1:$D$4,Tabelle1!$A$1:$A$4,"<="&A2,Tabelle1!$B$1:$B$4,">="&A2)
Apologies, can you give me an idea of how you used SUMIF() as I can't get it to work?
=SUMIFS(Tabelle1!$D$1:$D$4,Tabelle1!$A$1:$A$4,"<="&A2,Tabelle1!$B$1:$B$4,">="&A2)