That was PERFECT!!!

Thank you ALL

"Gary''s Student" wrote:

=SUM(P6:P106)-SUM(P83:P95)
--
Gary''s Student - gsnu200714


"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,