Sum based on 2 criteria

[bllanko2082]

Hello,

I need help on below;

Column A - I have the entry date
Column B - I have the client's name
Column C - I have a Reason
Column D - I have the Daily Cost
Column E - I have what they paid based on the date.

on cell E10, I need the sum for lines from E2:E4, that has 15May date entered. see the picture below; I'm trying to explain as much as I can. thanks... any idea?

 

[awoohaw]

try this:

Book1
	A	B	C	D	E
1	Entry Dt	Client	Reason	Daily Cost	Paid
2	2024-05-15	X3	Travel	234.10	2024-05-15
3	2024-05-15	X4	Travel	202.00	2024-05-15
4	2024-05-15	X5	Travel	99.00
5	2024-05-15	X6	Travel	507.60
6
7
8
9	Date	Daily Klient	Reason	Total Daily Cost	Paid Today
10	2024-05-15				436.10
11
12
Sheet2

Cell Formulas
Range	Formula
E10	E10	=SUMIF($E$2:$E$5,$A10,$D$2:$D$5)

 

[awoohaw]

@bllanko2082 , I don't understand the "like" without any comment? Did it answer your question, or did I misunderstand the question?

 

[bllanko2082]

@bllanko2082 , I don't understand the "like" without any comment? Did it answer your question, or did I misunderstand the question?

yes, thanks for your help; it worked.