Jul 17 2022 04:42 AM
Dear friends,
I need some help.
table 1
Total Sales Day Wise | |||||||||||||||
EMP Name | 01-07-2022 | 02-07-2022 | 03-07-2022 | 04-07-2022 | 05-07-2022 | 06-07-2022 | 07-07-2022 | 08-07-2022 | 09-07-2022 | 10-07-2022 | 11-07-2022 | 12-07-2022 | 13-07-2022 | 14-07-2022 | 15-07-2022 |
Liam | 4 | 13 | 20 | 11 | 72 | 13 | 15 | 11 | 12 | 7 | 9 | 5 | 9 | 6 | 3 |
Noah | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
Oliver | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
Elijah | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
James | 4 | 13 | 20 | 11 | 72 | 13 | 15 | 11 | 12 | 7 | 9 | 5 | 9 | 6 | 3 |
William | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
Benjamin | 4 | 13 | 20 | 11 | 72 | 13 | 15 | 11 | 12 | 7 | 9 | 5 | 9 | 6 | 3 |
Lucas | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
Henry | 4 | 13 | 20 | 11 | 72 | 13 | 15 | 11 | 12 | 7 | 9 | 5 | 9 | 6 | 3 |
Theodore | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
Olivia | 4 | 13 | 20 | 11 | 72 | 13 | 15 | 11 | 12 | 7 | 9 | 5 | 9 | 6 | 3 |
Emma | 4 | 13 | 20 | 11 | 72 | 13 | 15 | 11 | 12 | 7 | 9 | 5 | 9 | 6 | 3 |
Charlotte | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
Amelia | 4 | 13 | 20 | 11 | 72 | 13 | 15 | 11 | 12 | 7 | 9 | 5 | 9 | 6 | 3 |
Ava | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
Sophia | 4 | 13 | 20 | 11 | 72 | 13 | 15 | 11 | 12 | 7 | 9 | 5 | 9 | 6 | 3 |
Isabella | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
Mia | 4 | 13 | 20 | 11 | 72 | 13 | 15 | 11 | 12 | 7 | 9 | 5 | 9 | 6 | 3 |
Evelyn | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
Harper | 4 | 13 | 20 | 11 | 72 | 13 | 15 | 11 | 12 | 7 | 9 | 5 | 9 | 6 | 3 |
table 2
EMP Name | Date 1 | Date 2 | Total Sales Between 2 Date |
Liam | 01-07-2022 | 06-07-2022 | |
Noah | 03-07-2022 | 08-07-2022 | |
Oliver | 04-07-2022 | 09-07-2022 | |
Elijah | 01-07-2022 | 06-07-2022 | |
James | 03-07-2022 | 08-07-2022 | |
William | 04-07-2022 | 09-07-2022 | |
Benjamin | 02-07-2022 | 07-07-2022 | |
Lucas | 04-07-2022 | 09-07-2022 | |
Henry | 05-07-2022 | 10-07-2022 | |
Theodore | 02-07-2022 | 07-07-2022 | |
Olivia | 04-07-2022 | 09-07-2022 | |
Emma | 05-07-2022 | 10-07-2022 | |
Charlotte | 03-07-2022 | 08-07-2022 | |
Amelia | 05-07-2022 | 10-07-2022 | |
Ava | 06-07-2022 | 11-07-2022 | |
Sophia | 03-07-2022 | 08-07-2022 | |
Isabella | 05-07-2022 | 10-07-2022 | |
Mia | 06-07-2022 | 11-07-2022 | |
Evelyn | 04-07-2022 | 09-07-2022 | |
Harper | 06-07-2022 | 11-07-2022 |
I need the total sum of date 1 to date to date 2 from Table 1
please help me.
Jul 17 2022 05:05 AM
Jul 19 2022 09:06 AM
Jul 19 2022 11:12 AM
Yes, that's what the formula does.