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)
Chris,
your dates in the first table are from 2011 and the dates from the second table are from 2010. They will never match.
Thus the result is 0.
Hi Detlef,
I know this, this was just an example sample, the formula I am using also gives be 0 when when the dates are in the range, I'm looking at dates from 2010-2018 and the current set of data I'm testing on goes from 2011-2018, I'll be pulling data from further back when I can get the formula to work so I can see I'm getting the info I expect.
Please don't give bad examples.
If I change 01/01/2010 to 20/03/2011 I get 24000000.
SUMIFS() works.
Apologies, can you give me an idea of how you used SUMIF() as I can't get it to work?
