Problem in sumproduct with sumif formula

[Moin75]

Hi All,

I am stuck in one formula and need your help!!!.

I wanna calculate the number of particular documents from Sheet1 to sheet 2 which should show the number of documents in a certain date. for example in the attached excel in sheet 2, I used the formula =SUMPRODUCT(--(Sheet1!$D$3:$D$23=A3),--(Sheet1!K$3:K$23="EMD")) which is working fine but it is totaling the the number of documents on a particular date but not reading the location and calculating date with all the locations that i have input in the excel like location 321, 324.
My problem is, i wanna use the command which should read the particular location number along with the date.
like the answer i should get is where as i am getting the total EMD count as 5 on 1 sep.

[TABLE="width: 167"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Date [/TD]
[TD]Location[/TD]
[TD] EMD[/TD]
[/TR]
[TR]
[TD="align: right"]01-Sep[/TD]
[TD="align: right"]321[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]01-Sep[/TD]
[TD="align: right"]324[/TD]
[TD="align: right"]4[/TD]
[/TR]
</tbody>[/TABLE]

I am sure how well i explained my point here but i would be great if some one can help me as i am really stuck and need urgent help.


Thanks in advance.

Moin

 

[Aladin Akyurek]

1. SUMIFS...

=SUM(SUMIFS(EMD,Date,DATE(2017,9,1),Location,{321,324})

2. SUMPRODUCT...

=SUMPRODUCT(EMD,--(Dae=DATE(2017,9,1),--ISNUMBER(MATCH(Location,{321,324},0)))