Have a lool in the help index for SUMIF. For more conditions you can use
sumproduct((

--
Don Guillett
SalesAid Software

"Bongard" wrote in message
oups.com...
Hi, I am trying to get totals at the bottom of my report based on
another columns value. I am trying to sum all of the values to the
right of every instance of this value above. I tried a vlookup formula
but it only returns the first value where the logic is true. I will
give you my vlookup formula so that this may make more sense.
=VLOOKUP(K3037,K$4:L$3027,2,FALSE)
Where K3037 = 1.1, so I want the sum of the values (in column L) for
every instance of 1.1 in the range k4:k3027. There may be 10 instances
of 1.1 in column L in that range so the formula must take into account
all instances.

I hope this is clear and I appreciate any help in advance!

-Brian