Waffles255
New Member
- Joined
- Mar 30, 2019
- Messages
- 26
- Office Version
- 2019
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
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