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
--
Max
Singapore
---
"blnprescott" wrote:
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 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.


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Max" wrote:

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
--
Max
Singapore
---
"blnprescott" wrote:
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?