View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do I segment a column of data into size ranges in Excel?

I'll get out of way of the formula kings and address the Excel version question.

No Version of Excel comes with Windows XP.

Your seller must have installed MS Office or Excel on your computer.

To see which version, open Excel and HelpAbout.

You will see the version there.

Suggest you check the disks that came with your computer to see if your seller
provided any for MS Office or Excel.

You may need a disk at some point for a repair/re-install.


Gord Dibben MS Excel MVP

On Sat, 26 Aug 2006 15:07:24 -0700, "RagDyeR" wrote:

And needless to say, I *should* have said:

"Enter the row number of the cells to 'start' and 'end' into B1 & B2.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"RagDyeR" wrote in message
...
I didn't read the question as to performing any sort of calculation, but you
may be right.

SO ... to Sum a range of cells contained in Column A,
Enter the cell to *start* into B1,
And enter the *ending* cell into B2,
And try this:

=SUM(INDEX(A:A,B1):INDEX(A:A,B2))