Actually, the formula is more complicated than I originally wrote. It's
actually something like:
Cell L6 = K6-C6-(Any amount in excess of 3 in E6)



Does that make sense?
Kathy

Essentially, if the number in column E is
greater than 3, than I need to add the balance (meaning any number in
excess
of 3) to column L. Any help would be greatly appreciated.

--
Kathy


"Peo Sjoblom" wrote:

=SUMIF(E:E,"0",L:L)

or did you mean

=SUMIF(E:E,"3")


--
Regards,

Peo Sjoblom



"Kathy" wrote in message
...
Hi,
I need help creating a formula. Essentially, if the number in column E is
greater than 3, than I need to add the balance (meaning any number in
excess
of 3) to column L. Any help would be greatly appreciated.
--
Kathy