You probably want Sumif. It's hard to tell where your data is, so it's
difficult to come up with a formula based on what you've told us. If you
still have questions after looking it up in Help, post back.

Regards,
Fred.

"Craig" wrote in message
...
Hi I have a spread sheet as per below:
What I need is a formula to search for a fund code from the top and from
the
bottom, if they match I need the Gain/Loss figures to be added together.
Basically if any of the fund codes match in the upper portion with a fund
code in the lower than add the gain or loss together to come up with the
net
gain or loss.
If any of the cells within one range match any of the cells in the other
add
the applicable Gain/Loss together.


Purchase Backdate or Redemption Cancel
fund amount unit price price offset Gain/Loss
FID235
NBC100




Purchase Cancel or Redemption Backdate
fund amount unit price price offset Gain/Loss
AIM1633
FID235