In several cells I have =?+423.55 I want total w/o the 423.55.
 

I have a spreadsheet that has many cells in a column with different amounts
but all have 423.55, as an example =200.00+423.55, at the end of the column I
get a grand total. Is there a way for me to get a total that does not
include the 423.55?
Thanks Larry Heckman

In several cells I have =?+423.55 I want total w/o the 423.55.
 

=sum(range of cells)-423.55*count(range of cells)

"lheck77" wrote:

I have a spreadsheet that has many cells in a column with different amounts
but all have 423.55, as an example =200.00+423.55, at the end of the column I
get a grand total. Is there a way for me to get a total that does not
include the 423.55?
Thanks Larry Heckman

In several cells I have =?+423.55 I want total w/o the 423.55.
 

Does this work for you:

=SUM(A1:A100,-COUNTIF(A1:A100,"0")*423.55)

?
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"lheck77" wrote in message
...
I have a spreadsheet that has many cells in a column with different amounts
but all have 423.55, as an example =200.00+423.55, at the end of the column
I
get a grand total. Is there a way for me to get a total that does not
include the 423.55?
Thanks Larry Heckman