Calculate cells if another cell equals a specific date

[AnnyCav]

I know this should be an easy enough formula to find, but it is too hard to describe in a search(??) So I am posting it here with a visual so you have an idea of what I am talking about.

What I want to do is look at the date on the LIST and go to another sheet (Sheet2) and find that date on this other list in column E and then calculate the time in Column F if it is the same date.

Eg: The formula will look up Sheet 2, Column E and match it to the date for that list. If the date matches, I want it to ADD all the times in column F that matches that date in Column E. So the list for 3rd June is so far at 180 minutes.

Kind regards
Anny

 

[StephenCrump]

It sounds like you need a SUMIF? (Although I have actually used SUMIFS, because I think it makes more sense to put the sum_range argument first)

	A	B
1		Total
2	3 Jun 2024	80
3	11 Jun 2024	55
Sheet1

Cell Formulas
Range	Formula
B2:B3	B2	=SUMIFS(Sheet2!C$2:C$9,Sheet2!B$2:B$9,A2)

	A	B	C
1
2		3 Jun 2024	40
3		3 Jun 2024	20
4		3 Jun 2024	20
5		3 Jun 2024
6		11 Jun 2024	22
7		11 Jun 2024	33
8		20 Jun 2024	180
9		20 Jun 2024	45
10
Sheet2

 

[AnnyCav]

It sounds like you need a SUMIF? (Although I have actually used SUMIFS, because I think it makes more sense to put the sum_range argument first)

	A	B
1		Total
2	3 Jun 2024	80
3	11 Jun 2024	55
Sheet1

Cell Formulas
Range	Formula
B2:B3	B2	=SUMIFS(Sheet2!C$2:C$9,Sheet2!B$2:B$9,A2)

	A	B	C
1
2		3 Jun 2024	40
3		3 Jun 2024	20
4		3 Jun 2024	20
5		3 Jun 2024
6		11 Jun 2024	22
7		11 Jun 2024	33
8		20 Jun 2024	180
9		20 Jun 2024	45
10
Sheet2

YOU LEGEND! That worked a treat and I did not think of the "SUMIF". I'm disappointed in myself.
Thank you
Anny