Prev: Same problem.
Next: Count Consecutive string of same number
From: blnprescott on 28 Dec 2009 16:13
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?
From: Max on 28 Dec 2009 16:30
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?
From: ryguy7272 on 28 Dec 2009 16:34
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?
 | 
Pages: 1
Prev: Same problem.
Next: Count Consecutive string of same number