View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default calculated celles according to more then 1 condition

Hi

=SUMPRODUCT((A1:A20=D1)*(B1:B20=D2)*(C1:C20))

Where D1 & D2 are the names you want to sum by.

Mike

"-yuval" wrote:

Col B = name (text field)
Col C = Last name (text field)
Col D = Expences (number)

I would like to SUM to A1 total expences of a person (True on 2 conditions
on Col B
& Col C)

Name will apear more then once on A & B

Thanks a milion