THANK YOU!! I've been racking my brain trying to figure out what I was going
wrong. I can't believe it was that simple. You are a lifesaver!!!

LISA

"Marcelo" wrote:

Hi Lisa,

Are you looking for b5 - sum of d5:g5?

if yes use

=b5-sum(d5:g5)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Lisa" escreveu:

I keep getting #VALUE! message. Why doesn't this formula work? What am I
missing? There is no text in any of the fields, only numbers. HELP!!

=B5-(D5:G5)