subtracting ranges

[blnprescott]

In cell p94, I tried the formula =sum(d94:e94)-sum(f9494) and it does not
give me an answer in p94; can anyone help?

 

[Max]

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

 

[ryguy7272]

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.