Lookup Value Sum Between 2 Dates

New Contributor

Dear friends,

I need some help.

table 1

 Total Sales Day Wise              
EMP Name01-07-202202-07-202203-07-202204-07-202205-07-202206-07-202207-07-202208-07-202209-07-202210-07-202211-07-202212-07-202213-07-202214-07-202215-07-2022
Liam41320117213151112795963
Noah222222222222222
Oliver222222222222222
Elijah222222222222222
James41320117213151112795963
William222222222222222
Benjamin41320117213151112795963
Lucas222222222222222
Henry41320117213151112795963
Theodore222222222222222
Olivia41320117213151112795963
Emma41320117213151112795963
Charlotte222222222222222
Amelia41320117213151112795963
Ava222222222222222
Sophia41320117213151112795963
Isabella222222222222222
Mia41320117213151112795963
Evelyn222222222222222
Harper41320117213151112795963

table 2 

EMP NameDate 1Date 2Total Sales Between 2 Date
Liam01-07-202206-07-2022 
Noah03-07-202208-07-2022 
Oliver04-07-202209-07-2022 
Elijah01-07-202206-07-2022 
James03-07-202208-07-2022 
William04-07-202209-07-2022 
Benjamin02-07-202207-07-2022 
Lucas04-07-202209-07-2022 
Henry05-07-202210-07-2022 
Theodore02-07-202207-07-2022 
Olivia04-07-202209-07-2022 
Emma05-07-202210-07-2022 
Charlotte03-07-202208-07-2022 
Amelia05-07-202210-07-2022 
Ava06-07-202211-07-2022 
Sophia03-07-202208-07-2022 
Isabella05-07-202210-07-2022 
Mia06-07-202211-07-2022 
Evelyn04-07-202209-07-2022 
Harper06-07-202211-07-2022 

 

 I need the total sum of date 1 to date to date 2 from Table 1
please help me.

3 Replies

@Ntnk1999 

In U3:

 

=SUMIFS($B3:$P3,$B$2:$P$2,">="&S3,$B$2:$P$2,"<="&T3)

 

Fill down.

Hans Vogelaar Thank you for response.

But i want the employee lookup sum value from the 1st table to the 2nd table between 2 dates which is in the 2nd table.

@Ntnk1999 

Yes, that's what the formula does.