Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif & sumproduct | Excel Worksheet Functions | |||
SUMPRODUCT arguments | Excel Worksheet Functions | |||
multiple SUMIF arguments | Excel Discussion (Misc queries) | |||
sumproduct to count two arguments | Excel Worksheet Functions | |||
Can sumproduct do two {x,y,z} arguments? | Excel Worksheet Functions |