Multiple Criteria In Sumif

[Matthew]

I am sure some one can answer this,

I have a simple sheet
3 Columns

Date Location Value

I have another sheet

Date Location

On the second sheet the dates are selctetd from the ones on the 1st
but are a selection from it.

I need to find a value for the sum for each location where the dates
match.

So far all my attempts come to 0 or N/A

Please Help

 

[smartin]

I am sure some one can answer this,

I have a simple sheet
3 Columns

Date Location Value

I have another sheet

Date Location

On the second sheet the dates are selctetd from the ones on the 1st
but are a selection from it.

I need to find a value for the sum for each location where the dates
match.

So far all my attempts come to 0 or N/A

Please Help

Try SUMPRODUCT.

With the first sheet as Sheet1 and the second as Sheet2, and assume
Date, Location, and Value are columns A:C, with column headers in row 1.

In Sheet2 C2 and fill down as far as needed:
=SUMPRODUCT(--(A2=Sheet1!$A$2:$A$9999),--(B2=Sheet1!$B$2:$B$9999),(Sheet1!$C$2:$C$9999))

Where 9999 is a sufficiently large row to contain the data in Sheet1
(doesn't have to be exact).

A good explanation/tutorial of this technique is here:
http://xldynamic.com/source/xld.SUMPRODUCT.html