Re: Simplify formulas

Wai Wai,

Cutting your range down (to make testing easier):

=SUMPRODUCT((A1:A10>=LARGE(A1:A10,5))*(A1:A10))

will sum every value from the 5th largest to the largest. However, if you
have more than one value equal to the 5th value then they will all be added
in. If that is a possibility then use:

=SUMPRODUCT((A1:A10>LARGE(A1:A10,5))*(A1:A10))+LARGE(A1:A10,5)

Wich will only add one of the 5th largest values

HTH


Sandy
sandymann@xxxxxxxxxxxxxx
Replace@mailinator with @tiscali.co.uk


"0-0 Wai Wai ^-^" <x@xxxxx> wrote in message
news:uxy1QC6jFHA.708@xxxxxxxxxxxxxxxxxxxxxxx
>I would like to simplify the following formulas
> =SUM( LARGE(A1:A1000,{1,2,3...500}) )
>
> Is it possible to simplify "{1,2,3...500}"?
> Currently I need to type each number manually by myself, ie
> 1,2,3,4,5,6,7,8,9
> and so on which is time-consuming.
> Is there any expression which tells the computer that it's "from 1 to
> 500"?
>
> --
> Additional information:
> - I'm using Office XP
> - I'm using Windows XP
>
>
>


.

Relevant Pages

  • Re: Simplify infinite series with Sines???
    ... use a square wave as well and I'd get the same result too. ... it makes it easier to simplify; then using a saw/square wave for k=2 ... this that it is equal to a sum. ... the coefficient aof z^i in P is ...
    (sci.math)
  • Re: Problem using solve... keeps busy
    ... However, if you then simplify() the result, you get a *large* ... Then at the end of the sum, there are a few lines of other terms ... and you simplifyafter substitution (applying the ... a=x into the original equation ...
    (comp.soft-sys.matlab)
  • Re: Some questions about simplification
    ... When I try to calculate sum of ... sines or cosines, the calculator makes calculation in approximation ... SEQ SigmaLIST SIMPLIFY>> ...
    (comp.sys.hp48)
  • Re: Prolog Programming for AI, problem 7.1
    ... but have run into a nasty exercise. ... Write a procedure 'simplify' to symbolically simplify summation ... % The idea is to calculate the numeric sum, ... % a list of the atoms in the compound expression, ...
    (comp.lang.prolog)
  • Re: Simplify formula for iterative programming
    ... character set is getting munged. ... >I wondered I anybody knew about analog simplifications to simplify H: ... >This simplied formula is much easier in iterative programming, ... If, as I guessing, your H is the sum over i,j of point distances from ...
    (comp.programming)