tow criteria (Date and Name)in sumif
Don't use sumif, go ahead and use
=Sumproduct (--(range=condition),--(range=condition),range)
The last range is to add how much money
--------------------------------------------------------------------------------
Sam Sebaihi Faculty Western International University Associate Programs
"Rolf" wrote in message
...
in a1,2,3,4 i have Name(brian,brenda,chris)
in b1,2,3,4 i have $ (500, 150,200)
in c1,2,3,4 I have Date (1/15/2006, 2/20/2006, 1/20/2006)
the result i need is: how many money brian in january, februar and so on.
Hope i get help and thank you in advance.
|