PeterWhitts

asked on

# Excluding from a sum formula numbers like 234.50%

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

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

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thanks Brad

Thats seems to work very well.

Nice to hear from you again.

Best wishes

Peter

Thats seems to work very well.

Nice to hear from you again.

Best wishes

Peter

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)