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

[Bodin]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Date[/TD]
[TD]Market[/TD]
[TD]Spent[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]01.01.2017[/TD]
[TD]Roda[/TD]
[TD]$1500[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]01.01.2017[/TD]
[TD]Roda[/TD]
[TD]$500[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]01.01.2017[/TD]
[TD]Maxi[/TD]
[TD]$1000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]02.01.2017[/TD]
[TD]Roda[/TD]
[TD]$740[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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