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)