Sumif i have a start date and an end date but i want to sum one day in between those days.

[Waffles255]

Hi, I am a bit slow today I would like to do the following :

Source Data As Follow:
------------------------------Start Date-----End Date-----NUmber People---Camp Site-----Course
Course 1 Duration From 01/05/2020 - 20/05/2020-----------18-------------MAKU---------Course1
Course 2 Duration From 01/05/2020 - 10/08/2020-----------23--------------Selatu-------- Course 2
Course 3 Duration From 08/05/2020 - 30/09/2020------------33-------------Makado----Course 3
Course 4 Duration From 01/05/2020 - 03/05/2020------------4---------------Maku---------Course 4


What i would like to do is make a table of the number of people in a camp on every day as per the following :
---------------- MAKU---Selatu---Makado
01/05/2020 =18+4
02/05/2020
03/05/2020
04/05/2020

SO i want to sum the number of people in camp on that specific day for example on the 01/05/2020 there were 18 + 4 People in Maku Camp

 

[Fluff]

Can you please post your data using the XL2BB add-in?

Also please update your account details to show what version of Excel you are using, as that affects what functions you have.
Thanks

 

[Waffles255]

sales report Alan.xlsx
	A	B	C	D	E
9		Start Date	End Date	People	Camp Site
10	Course 1	01/05/2020	20/05/2020	18	Maku
11	Course 2	01/05/2020	10/08/2020	23	Selatu
12	Course 3	08/05/2020	30/09/2020	33	Makado
13	Course 4	01/05/2020	03/05/2020	4	Maku
Sheet18

sales report Alan.xlsx
	A	B	C	D
2		Maku	Selatu	Makado
3	01-Jul-20
4	02-Jul-20
5	03-Jul-20
Sheet17

 

[Toadstool]

Edited

 

[Waffles255]

Apologies MAKU is the Same as Maku same site just how the data was captured

 

[Fluff]

Thanks for that
How about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I	J
1
2		Selatu	Karongwe	Camp	Maku	Botswana	Pridelands	Kenya	Other Venues	Online
3	01/05/2020	23	0	0	22	0	0	0	0	0
4	02/07/2020	23	0	0	0	0	0	0	0	0
5	03/07/2020	23	0	0	0	0	0	0	0	0
Data

Cell Formulas
Range	Formula
B3:J5	B3	=SUMIFS(Sheet18!$D$10:$D$13,Sheet18!$B$10:$B$13,"<="&$A3,Sheet18!$C$10:$C$13,">="&$A3,Sheet18!$E$10:$E$13,B$2)

Note the headers need to match the values in col E

 

[Waffles255]

Perfect Thank you I see where I went wrong you're a lifesaver thank you.

 

[Fluff]

Glad we could help & thanks for the feedback.