Sum

  • Thread starter Thread starter Shihab
  • Start date Start date
S

Shihab

Dear All,

I have a list of values, say, in column B. Some are
amounts (can be with decimal places)and others are
percentages formated as %. I just want to add the amounts
and not the percentages. Can I do that?

Thanks for your help.

Shihab
 
If all of your numbers you want to sum are 1 or greater and all of your
"percentages" are less than 1, this should work..........

=SUMIF(A1:A4,">=1")

Vaya con Dios,
Chuck, CABGx3
 
Hi,

Thanks for your reply. Unfortunately some of the amounts
are less than 1. This has become complicated! Thanks
anyway.

Regards

Shihab
 
I don't know if this is bad practice but if you precede the percentage with
an apostrophe and right-align it then a simple SUM f unction will ignore it.
If you need to use the percentage as a percentage then multiplying it will
coerce it into a number as in: A5*B5 where A5 is '17.5% and B5 is 150.

HTH

Sandy
 
Anything between -1 and 1 (exclusive) counts as a percentage?
=SUMPRODUCT(--(ABS(A1:A4)>1))

Get rid of the = sign if you want 1 and -1 to sum, too.
=SUMPRODUCT(--(ABS(A1:A4)>=1))
 
Back
Top