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
|