conditional sum with OR-type criteria

[dzorug]

hi all,

here's the background:

i need to sum the deals made by each manager of a group, but sometimes
one deal is handled by two managers.

so i have the deal amount in column A. the manager who handled the deal
is in column C. if there's a second manager, it's put in column D.

i need to add up the cells in A where the name in the same C or D rows
are equal to XXX.

i tried using =SUMIF((C150),"XXX",(A1:A50)), but it doesn't work
because if D20 is XXX, for example, it adds up B20 instead of A20.

any help appreciated. thanks all, and have a good holiday
-dzorug

 

[akyurek]

=SUMPRODUCT(($C$1:$D$50=F2)*$A$1:$A$50)

where F2 houses a manager of interest.