subtracting ranges

  • Thread starter Thread starter blnprescott
  • Start date Start date
B

blnprescott

In cell p94, I tried the formula =sum(d94:e94)-sum(f94:o94) and it does not
give me an answer in p94; can anyone help?
 
Probably you have text numbers in the 2 ranges, that's why
Try a: +0 (add a zero) to coerce it to real numbers
In P94, array-enter, ie press CTRL+SHIFT+ENTER to confirm the formula:
=SUM(D94:E94+0)-SUM(F94:O94+0)
Success? hit the yes below
 
Probably what Max said. You can see what the data is by using these simple
functions:
=istext(p94)
If result = TRUE, this is text

=isnumber(p94)
If result = TRUE, this is a number

Looks like you are already using =istext() so you are probably aware of this
little trick.
 
Back
Top