New Excel User - Conditional Formula help

[1stGenHeel]

I need assistance with a conditional formula that will filter on two fields, and then add two values that are on the same line if the two conditions are met.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Ex.
Cell A1 = 06/25/2011
Cell B1 = John Smith
Cell C1 = Value1
Cell D1 = Value2
<o> </o>
Desired result = If A1 = 06/25/2011 and B1 = John Smith, add C1 and D1
<o> </o>
The formula (and results) will be on a different worksheet from the actual data.

 

[VoG]

Try

=IF(AND(A1="06/25/2011"+0,B1="John Smith",C1+D1,"")

 

[T. Valko]

I need assistance with a conditional formula that will filter on two fields, and then add two values that are on the same line if the two conditions are met.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Ex.
Cell A1 = 06/25/2011
Cell B1 = John Smith
Cell C1 = Value1
Cell D1 = Value2
<o></o>
Desired result = If A1 = 06/25/2011 and B1 = John Smith, add C1 and D1
<o></o>
The formula (and results) will be on a different worksheet from the actual data.

Try this...

=IF(AND(A1=DATE(2011,6,25),B1="John Smith"),C1+D1,"")

 

[1stGenHeel]

Thanks that works, except I may have left some information out.

When I am looking for the date and name I will be looking through a range of cells, instead of just a single cell.

When I try that same formula using a range for A and B it returns an error.

Any ideas?

 

[Jonmo1]

Try

=SUMPRODUCT((A1:A100="6/25/2011"+0)*(B1:B100="John Smith")*(C1:D100))

 

[1stGenHeel]

Jonmo1 thanks for the reply. That solved the array for date and name, but I get N/A if I try to add an array for the final portion of that formula.

=SUMPRODUCT((A1:A100="6/25/2011"+0)*(B1:B100="John Smith")*(C1:D100))

I apologize for asking so many questions, but what I was hoping to do is this:

If A3 = 06/25/2011, and B3 = John Smith, return the value that is in C3
or
If A3 = 06/25/2011, and B3 = John Smith, return the value C3+D3

So in example 1, without having to specify E3, I was hoping that by using C1:D100 if the other two criteria were met on A3 and B3, the formula would return C3.

 

[Jonmo1]

Sorry, I don't see the difference between the criteria in the 2 lines

If A3 = 06/25/2011, and B3 = John Smith, return the value that is in C3
or
If A3 = 06/25/2011, and B3 = John Smith, return the value C3+D3

Those 2 look exactly the same to me...

 

[1stGenHeel]

Sorry, I should have just used one example. The second example was just to indicate I may do simple adding/subtracting of two different cells.

Just looking at example 1, if I try to put a range for the C3 values it returns an N/A.