Help with Formula (Excel 2003)
=SUM(P6:P106)-P83:P95
I thought for sure that was going to be easy, but it was not.
Hi. Just to add: With one Sum Formula, you need to enter the equation with
Ctrl+Shift+Enter.
=SUM(P6:P10, -P83:P95)
--
HTH :)
Dana DeLouis
Windows XP & Office 2007
"Marilyn" wrote in message
...
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,
|