SUMIF (SUMPRODUCT?) with two arguments
Something like this should work ok
In M3: =SUMPRODUCT(($A$3:$A$100=L3)*($B$3:$B$100="Tom"),$ C$3:$C$100)
Real dates are assumed in col A and in L3, real numbers assumed in col C
voila? hit YES below
--
Max
Singapore
---
"RHicks" wrote:
Column A is a list of dates
Column B is a list of names
Column C is a list of dollar amounts
Column L is a list of dates
Cell L3 value is "3/1/10"
Cell M3 needs to return the sum of Column C, but only when the Column A
value matches Cell L3, and also Column B matches "Tom"
|