Re: Summing a function

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Or maybe if I have two cells, with the starting integer in A1 and the
ending integer in A2 the funciton would look as follows:
SUMFUCNC((A1:A2)^2). This would also return 1+4+9+...+100.

Let's see A1 for first integer, and B1 as last integer, use this array
formula:
=SUM(ROW(INDIRECT("A"&INDIRECT("A1")&":B"&INDIRECT("B1")))^2)

Regards,
Daniel

.

Relevant Pages

  • Re: Can not compile
    ... Ting ... >> referenced by gActiveXObj. ... > the embedded 'count' member contained in the bounded array data type. ... > (First integer is the length, ...
    (microsoft.public.vb.general.discussion)
  • Re: Summing a function
    ... HTH. ... Windows XP, Office 2003 ... ending integer in A2 the funciton would look as follows: ...
    (microsoft.public.excel.worksheet.functions)
  • Arrays and Pointers
    ... array to keep track of 'n' number of object(The code snippet below is ... object in the next element array. ... calling the funciton then it gets added in fine. ... and the array keeps a copy of the object instead of a pointer? ...
    (comp.lang.php)
  • .net COM interface: how to interface a fuction returning array
    ... compiled a COM class DLL in dotnet vb. ... funciton works except those with array. ... I do I force the proper interface on those functions so legacy application ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Dynamic Object Naming
    ... private System.Windows.Forms.PictureBox[] pictureBox; ... ///i put this in the funciton ... Do i need to put it into an array or something? ...
    (microsoft.public.dotnet.languages.csharp)