Adding up numbers that fall in a range of dates (not as simple as it sounds)

Question

Hi All&nbsp;I assume that this isn't that complicated and I am just lacking the correct terms to find the answers. I just get solutions to kind of the opposite problem when I try.&nbsp;Here is my problem ...We generate a spreadsheet with events (multiple days) and numbers of staff e.g.Start date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Number of staff working1 Jan 21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3 Jan 21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52 Jan 21 &nbsp; &nbsp; &nbsp; &nbsp; 2 Jan 21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 35 Jan 21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10 Jan 21&nbsp;&nbsp;&nbsp;&nbsp; 10What I would ideally like is to then have a second sheet with all the dates of the year in column A and then how many staff are working on that date so with the above it would look like1 jan 21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52 jan 21 &nbsp; &nbsp; &nbsp; &nbsp; 83 jan 21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 54 jan 215 jan 21 &nbsp; &nbsp; &nbsp; &nbsp; 106 Jan 21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10Etc....Is that possible?&nbsp;I'm not wedded to the other sheet idea I just thought that would be easiestI hope I have posted this in the right placeThanks so muchAndy

hansvogelaar · Accepted Answer

Andy_Godfrey&nbsp;
Let's say that you enter the dates 1-Jan-21, 2-Jan-21 etc. in F2 and down.
Enter the following formula in G2:
&nbsp;
=SUMIFS($C$2:$C$100,$A$2:$A$100,"&lt;="&amp;F2,$B$2:$B$100,"&gt;="&amp;F2)
&nbsp;
Adjust the ranges, then fill down.
&nbsp;

Forum Discussion

Adding up numbers that fall in a range of dates (not as simple as it sounds)

2 Replies