Sum based on multiple criteria

[Rnelson333]

Hi there,

I am usually able to find the answer to my issue within the forum, however this time I am not sure if I have seen it or not...haha

Here is what I am trying to do. I would like to summarize on a separate sheet, sales based on month and item.

DataSheet

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Date[/TD]
[TD]Item[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2016/01[/TD]
[TD]Black
[/TD]
[TD]201.25[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2016/02[/TD]
[TD]Red[/TD]
[TD]25.36[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2016/01[/TD]
[TD]White[/TD]
[TD]24.95[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2016/03[/TD]
[TD]Green[/TD]
[TD]205.65[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]2016/02[/TD]
[TD]Black[/TD]
[TD]85.25[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]2016/01[/TD]
[TD]Black[/TD]
[TD]98.75[/TD]
[/TR]
</tbody>[/TABLE]

SummarySheet

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Date[/TD]
[TD]Item[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2016/01[/TD]
[TD]Black[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


What I would like, is on the "SummarySheet" in Cell C2 sum all the amounts from the table on the "DataSheet" with a date of 2016/01 and an Item as Black. The total should return 300.00 in C2 on the SummarySheet

I believe I should use a SUMIF() combined with a MATCH() however I am not sure how to do that. Any help would be appreciated.

 

[BarryL]

=SUMIFS(DataSheet!C:C,DataSheet!A:A,A2,DataSheet!B:B,B2)

 

[63falcondude]

Try =SUMIFS(DataSheet!C:C,DataSheet!A:A,SummarySheet!A2,DataSheet!B:B,SummarySheet!B2)

 

[Rnelson333]

Thank you 63falcondude that works great. I guess I was over complicating things with the Match()

 

[63falcondude]

Thank you 63falcondude that works great. I guess I was over complicating things with the Match()

Glad to help.