View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
-yuval[_2_] -yuval[_2_] is offline
external usenet poster
 
Posts: 3
Default calculated celles according to more then 1 condition

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