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

Not clear, please give one simple example of what you need to do
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"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

Hi Bernard,
Okay, here goes.

I am doing research on probabilities between astrological aspects of the
planets and occurences of people showing up to class. So I have"

Column A == the astrological aspects that happen at the time of the class
there will be anywhere from 1 to x# of possible aspects which could change

Then in columns B thru XX will indicate the number of students that show up
to the classes through out the campus so at any one time there could be the
least number of 1 to the most number at this time of 155.

Right now I have it set up this way:
Column A B C D E F G H I J K L
and so forth to 156
1 2 3 4 5 6 7 8 9 10 11
to 156
mars sq sun

and when mars is squaring the sun I will a hash mark beneath each column to
indicate how many students are in class at that time, there usually are no
more than ten classes going at one time that I am following. So what I
would like to be able to do is to simply have ten areas that I could just
fill in the numbers in ten different cells and they will "magically " go to
their respective places in the colums to be added to the other times that
mars squared the sun and I tallied the students. I hope this makes more
sense. And I greatly appreciate any thoughts and help.

--
Thanks, Mobilenetmomma the eternal student


"Bernard Liengme" wrote:

Not clear, please give one simple example of what you need to do
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"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

Have a look at SUMIF
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"mobilenetmomma" wrote in message
...
Hi Bernard,
Okay, here goes.

I am doing research on probabilities between astrological aspects of the
planets and occurences of people showing up to class. So I have"

Column A == the astrological aspects that happen at the time of the class
there will be anywhere from 1 to x# of possible aspects which could change

Then in columns B thru XX will indicate the number of students that show
up
to the classes through out the campus so at any one time there could be
the
least number of 1 to the most number at this time of 155.

Right now I have it set up this way:
Column A B C D E F G H I J K L
and so forth to 156
1 2 3 4 5 6 7 8 9 10
11
to 156
mars sq sun

and when mars is squaring the sun I will a hash mark beneath each column
to
indicate how many students are in class at that time, there usually are no
more than ten classes going at one time that I am following. So what I
would like to be able to do is to simply have ten areas that I could just
fill in the numbers in ten different cells and they will "magically " go
to
their respective places in the colums to be added to the other times that
mars squared the sun and I tallied the students. I hope this makes more
sense. And I greatly appreciate any thoughts and help.

--
Thanks, Mobilenetmomma the eternal student


"Bernard Liengme" wrote:

Not clear, please give one simple example of what you need to do
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"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

thank you, but I am really dumb about this...what are SUMIF 's?
--
Thanks, Mobilenetmomma the eternal student


"Bernard Liengme" wrote:

Have a look at SUMIF
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"mobilenetmomma" wrote in message
...
Hi Bernard,
Okay, here goes.

I am doing research on probabilities between astrological aspects of the
planets and occurences of people showing up to class. So I have"

Column A == the astrological aspects that happen at the time of the class
there will be anywhere from 1 to x# of possible aspects which could change

Then in columns B thru XX will indicate the number of students that show
up
to the classes through out the campus so at any one time there could be
the
least number of 1 to the most number at this time of 155.

Right now I have it set up this way:
Column A B C D E F G H I J K L
and so forth to 156
1 2 3 4 5 6 7 8 9 10
11
to 156
mars sq sun

and when mars is squaring the sun I will a hash mark beneath each column
to
indicate how many students are in class at that time, there usually are no
more than ten classes going at one time that I am following. So what I
would like to be able to do is to simply have ten areas that I could just
fill in the numbers in ten different cells and they will "magically " go
to
their respective places in the colums to be added to the other times that
mars squared the sun and I tallied the students. I hope this makes more
sense. And I greatly appreciate any thoughts and help.

--
Thanks, Mobilenetmomma the eternal student


"Bernard Liengme" wrote:

Not clear, please give one simple example of what you need to do
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"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

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

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

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

Hi Rick,
I guess I am being really dense, and I apologize. I need ten columns and
each of those ten columns should be able to accept upto the numbers 156 so
that lets say I needed to put a 16 in the first column on one day but then on
the next day I need to put a 95 and perhaps the third day I need to put a 1
in that same column. I will need 10 colums that will allow me to enter
varying numbers in each of the columns and there might be instances when in
the first column I will have the same number as perhaps the fourth column and
also the tenth column.

I am beginning to believe that this is not as simple as I thought it might
be. Thanks for all of your help!
--
Thanks, Mobilenetmomma the eternal student


"Rick Rothstein (MVP - VB)" wrote:

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

I think you are still missing the point of my question. When you say "I need
ten columns"... my question is not that there are 10 of them, but which 10
are they. In your first post, you said "I simply type in the numbers I need
in each column and then the numbers are "magically" added to the correct
number columns". My question is... what are the number of these 10 "correct
columns"? And, once you tell me the column numbers where you want your
numbers to finally be placed at, I also want to know if these 10 "correct
column" numbers are **always** going to be the same 10 column numbers. I'm
not asking for a the one or two columns you might fill in the first day, and
the one or two the next day... what I want to know is **all** the "correct
column" numbers that will ever be filled in by you as explained in your
first message.

I don't think this will be hard to do; but first we must understand your
setup and how you want/need to interact with it. When answering our
questions, keep in mind we know absolutely nothing about your worksheet...
specifically, we don't know how it is laid out... so you have to tell us...
don't make us guess (because we will probably guess wrong<g).

Rick


"mobilenetmomma" wrote in message
...
Hi Rick,
I guess I am being really dense, and I apologize. I need ten columns and
each of those ten columns should be able to accept upto the numbers 156 so
that lets say I needed to put a 16 in the first column on one day but then
on
the next day I need to put a 95 and perhaps the third day I need to put a
1
in that same column. I will need 10 colums that will allow me to enter
varying numbers in each of the columns and there might be instances when
in
the first column I will have the same number as perhaps the fourth column
and
also the tenth column.

I am beginning to believe that this is not as simple as I thought it might
be. Thanks for all of your help!
--
Thanks, Mobilenetmomma the eternal student


"Rick Rothstein (MVP - VB)" wrote:

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