What function to use to get data i need on 2 criteria (date and name)

[Bodin]

	B	C	D	E
1	Date	Market	Spent
2	01.01.2017	Roda	$1500
3	01.01.2017	Roda	$500
4	01.01.2017	Maxi	$1000
5	02.01.2017	Roda	$740

<tbody>
</tbody>

I try with =sumif, but it sum all on roda.
What function to use to get how much money i spend in chosen market (1st criteria) on chosen date (2nd criteria)?
I try to watch over my finance, and till this year i watched it manually.

Tnx, all

 

[AlanY]

could try the sumifs() function that works for multiple criteria

 

[Bodin]

I tried this:
=SUMIF(B2:D5,E1,D2:D5)
Where in E1 i put market that i need, but it calculate all spents in that market per month (i have data for whole last year)

 

[Bodin]

Sorry, didnt saw sumifS

 

[Bodin]

Fantastic. Tnx.
Topic closed