View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
SAM SEBAIHI SAM SEBAIHI is offline
external usenet poster
 
Posts: 58
Default 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.