<div>
Assuming the numbers are in the cell range A1:A6<br />
<br />
If you add a column to the right of the numbers which has the following formula:<br />
<br />
=CELL(&quot;format&quot;;A1)<br />
=CELL(&quot;format&quot;;A2)<br />
....<br />
<br />
<br />
Which will show G for GENERAL format and P2 for PERCENT with two decimals<br />
<br />
Then you can use the following formula to exclude percentages from the sum:<br />
<br />
&nbsp; &nbsp;SUMIF(B1:B6;&quot;G&quot;;A1:A6)
</div>


Assuming the numbers are in the cell range A1:A6

If you add a column to the right of the numbers which has the following formula:

=CELL("format";A1)
=CELL("format";A2)
....


Which will show G for GENERAL format and P2 for PERCENT with two decimals

Then you can use the following formula to exclude percentages from the sum:

   SUMIF(B1:B6;"G";A1:A6)

<div>
Thanks Brad<br />
Thats seems to work very well.<br />
Nice to hear from you again.<br />
Best wishes<br />
Peter
</div>


Thanks Brad
Thats seems to work very well.
Nice to hear from you again.
Best wishes
Peter

<div>
<div class="content wysiwyg-content">
in Excel 2007 I have a column with numbers in like:<br />
<br />
123.00<br />
&nbsp;34.99<br />
236.99<br />
124.66% &nbsp; this is actually how the number is and is not formatted<br />
334.78<br />
22.56<br />
<br />
What I need is a sum type formula that covers the whole column range of numbers but excludes all numbers that end in % from the total<br />
<br />
Many thanks
</div>
</div>


in Excel 2007 I have a column with numbers in like:

123.00
 34.99
236.99
124.66%   this is actually how the number is and is not formatted
334.78
22.56

What I need is a sum type formula that covers the whole column range of numbers but excludes all numbers that end in % from the total

Many thanks

Excluding from a sum formula numbers like 234.50%

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.