Excel SUMIF function problem
One way
=SUMPRODUCT(--(A1:A1000="v"),--(B1:B1000<""),C1:C1000)
note that you need to set a range when using SUMPRODUCT in versions prior to
2007 so you can't use A:A as a range
--
Regards,
Peo Sjoblom
"harperma" wrote in message
...
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.
|