Hi all,
I'm trying to use something along the lines of the 'sumif' formula but with
a twist.
Basically, i have Column A with a list of repeating names names in no fixed
order. Then in Column B is another list of different but repeating names in
no fixed order. And in Column C is a list of amounts in pounds £.
What i want to do is to look down the complete list of names in column A for
a name 'v' and then look down the list in column B for any name 'w,x,y & z'
and add together all the amounts in column C where V+'w,x,y & z' are present.
In other words if there is a blank in column B the amount in column C will be
ignored.

Sounds really complecated to me and im sure there really is a simple way of
doing it but im too close to the problem to see it, So any help will be
greatly received.
Many Thanks in advance.
MARK.