why doesn't this formula work?
 

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)

why doesn't this formula work?
 

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)

why doesn't this formula work?
 

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)

why doesn't this formula work?
 

glad to help, thanks for the feedback
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Lisa" escreveu:

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)

why doesn't this formula work?
 

1st what ru trying to do with the values (D5:G5)
maybe the formula should read =b5-sum(d5:g5) or use average or max or count
etc

"Lisa" wrote:

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)