Help with Formula (Excel 2003)
Hi Marilyn,
=SUM(P6:P106)-SUM(P83:P95)
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"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,
|