Help with Formula (Excel 2003)
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, |
Help with Formula (Excel 2003)
=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, |
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, |
Help with Formula (Excel 2003)
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, |
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, |
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, |
All times are GMT +1. The time now is 05:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com