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