If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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" |
Thread Tools | |
Display Modes | |
|
|