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" |
All times are GMT +1. The time now is 01:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com