View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_91_] Rick Rothstein \(MVP - VB\)[_91_] is offline
external usenet poster
 
Posts: 1
Default how to do number additions in a spread sheet faster

But are the column numbers your 10 pieces of data going in always the same
10 columns (specifically, the 10 you mentioned in your first post)?

Rick


"mobilenetmomma" wrote in message
...
Hi Rick
The number of cells will most probably stay at 10, but there is a
possibility that it will increase.
The column numbers will be chronological starting with 1 and running
through
156. I want to have to only be concerned with filling in 10 cells with
numbers that will "magically" find their ways to their respectively
numbered
column and add themselves to any other number that is there so that I will
have a running total in each cell in this "magic" land that I can then
look
at and analyze. Thank you so much for your help!
--
Thanks, Mobilenetmomma the eternal student


"Rick Rothstein (MVP - VB)" wrote:

Are there always only 10 cells to fill in, or could this number change
with
each set of cells to be filled in?

Are the column numbers to be filled in always 1, 45,67,99,345,678,and
987,
or can the column numbers vary with each set of cells to be filled in?

Rick


"mobilenetmomma" wrote in
message
...
I am doing research on numbers. I have been entering the numbers in a
very
time consuming and potentially error ridden manner....the old fashioned
way
by scrolling through the colums and then when I come to the column I
want
to
add a number to stopping at that column changing the number that was
there
to
indicate another addition of that number then pressing enter and then
on
to
the next number. THERE HAS TO BE A SIMPLER WAY, BUT I DON'T KNOW
ENOUGH
TO
KNOW HOW TO DO IT!

Column A B C D E F............xx
December 1 2 3 4 5............22259

I am only entering in 10 numbers into each row under each number
column,
but I have to scroll all the way accross until i get to each number
column's
column . i.e. I could have to add #'s 1, 45,67,99,345,678,and 987 but I
need
to scroll from 1 to 45 then onto all the others. I want to be able to
have
my row look like this
Column A B C D E F G H I J K
December __ __ __ __ __ __ __ __ __ __
and then I simply type in the numbers I need in each column and then
the
numbers are "magically" added to the correct number columns. I hope
this
makes sense to someone and can help me.

--
Thanks, Mobilenetmomma the eternal student