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