Re: excel SUM function - can it be limited to whats in parentheses?

Tech-Archive recommends: Speed Up your PC by fixing your registry

I agree with what Dave F. wrote--life will be lots easier for lots of things if
you put your data in separate fields.

But this worked ok for me:

=SUMPRODUCT(--SUBSTITUTE(MID(A1:A3,SEARCH("(",A1:A3,1)+1,255),")",""))
Adjust the range to match your data

liillith wrote:

eIs there a way to limit teh =SUM() excel function to what is in the
parentheses in each given line that is being added up? example:
assorted wraps ($7.50)
cookies (1.00)
sodas (1.35)
Total:
and then having it total just the amounts in the parenteses and disregarding
everything else in the box?

--

Dave Peterson
.

Relevant Pages

  • Re: sumif, multiple criteria
    ... So is it still missing any brackets or parentheses? ... can't use full-column references, as Dave points out. ...
    (microsoft.public.excel.misc)
  • Re: How do I handle errors in value function
    ... That suggest to me that we have put a parentheses in the wrong place. ... Absolute minimum query - ... try adjusting it until it works. ... Dave wrote: ...
    (microsoft.public.access.queries)
  • Re: Simplifying Algebraic expression
    ... to insert parentheses to avoid ambiguity. ... Dave L. Renfro ...
    (sci.math)
  • Re: operating with binary
    ... No, Dave is right. ... The parentheses, whether or not necessary in C, ... greatly improve the readability. ... Subjective observation. ...
    (comp.lang.c)
  • Re: operating with binary
    ... snip ... ... Kindly consult an operator precedence table. ... No, Dave is right. ... The parentheses, whether or not necessary in C, ...
    (comp.lang.c)