Help with Formula (Excel 2003)
Hi,
If you take the sum value of the range of cells, then if you must enter the
following formula
for example, =SUM(G6:G10)-SUM(H6:H10)
Challa Prabhu
"Marilyn" wrote:
I'm trying to create a formula that SUMs a range of cells and then Subtracts
from a different range. I typed the following in Excel and I get a #value
error:
=SUM(P6:P106)-P83:P95
I thought for sure that was going to be easy, but it was not. What Am I
doing wrong?
Thanks,
|