Collecting data
 

I'm using Office 2003 with Windows XP. I have no idea how to look this up
because I don't know what to call it, but I'm told it can be done.

I'd like to tell Excel (for example) that for each row in column M that
equals 5, then take the number in that same row from column N and add those
all together and put the total on Row 85 of column Z.

I want to do that for each of more than ten different numbers in column M.

Further, I'd like to tell Excel to collect the numbers in 85 Z from all (or
specified) pages in the workbook and place them on 85 Z on a specified page.

As you can probably tell, I want to automate a budget report. This has to be
the kind of thing Excel is made to do, I just don't know what to call it to
look it up.
--
Thanks!

Collecting data
 

It's called a conditional sum, and one way of achieving it is to use the
function SUMIF like this:

=SUMIF(M:M,5,N:N)

This does exactly what your second paragraph asks for, and you will put this
formula in cell Z85.

The second part of your post is a bit confusing - you can only have one
formula in a cell, so if you want to get the sum for 10 different numbers
then you will have to have a similar formula but in 10 different cells. The
only difference in the formulae will be the number 5 in the middle.

If you can put the 5 (and 9 other numbers that you are interested in) in
another cell, such as Y85, Y86, Y87 etc., then you can amend the formula in
Z85 to this:

=SUMIF(M:M,Y85,N:N)

and then copy this formula down into the cells Z86:Z94.

Hope this helps.

Pete

"Mary Lee" wrote in message
...
I'm using Office 2003 with Windows XP. I have no idea how to look this up
because I don't know what to call it, but I'm told it can be done.

I'd like to tell Excel (for example) that for each row in column M that
equals 5, then take the number in that same row from column N and add
those
all together and put the total on Row 85 of column Z.

I want to do that for each of more than ten different numbers in column M.

Further, I'd like to tell Excel to collect the numbers in 85 Z from all
(or
specified) pages in the workbook and place them on 85 Z on a specified
page.

As you can probably tell, I want to automate a budget report. This has to
be
the kind of thing Excel is made to do, I just don't know what to call it
to
look it up.
--
Thanks!

Collecting data
 

I think so, Pete - I made my examples too truncated, I guess. What you are
saying makes sense. I am trying to gather all of the data totals I need for
each month (one month to a worksheet), then get those results from each
previous month in the same workbook and put them in each month's YTD. Yes, of
course, the results would have to each be in their own cell.

At least I now have a term to search for if I run into trouble when I try to
implement it. I assume I can also do some kind of macro once I get it worked
out?
--
Thanks!


"Pete_UK" wrote:

It's called a conditional sum, and one way of achieving it is to use the
function SUMIF like this:

=SUMIF(M:M,5,N:N)

This does exactly what your second paragraph asks for, and you will put this
formula in cell Z85.

The second part of your post is a bit confusing - you can only have one
formula in a cell, so if you want to get the sum for 10 different numbers
then you will have to have a similar formula but in 10 different cells. The
only difference in the formulae will be the number 5 in the middle.

If you can put the 5 (and 9 other numbers that you are interested in) in
another cell, such as Y85, Y86, Y87 etc., then you can amend the formula in
Z85 to this:

=SUMIF(M:M,Y85,N:N)

and then copy this formula down into the cells Z86:Z94.

Hope this helps.

Pete

"Mary Lee" wrote in message
...
I'm using Office 2003 with Windows XP. I have no idea how to look this up
because I don't know what to call it, but I'm told it can be done.

I'd like to tell Excel (for example) that for each row in column M that
equals 5, then take the number in that same row from column N and add
those
all together and put the total on Row 85 of column Z.

I want to do that for each of more than ten different numbers in column M.

Further, I'd like to tell Excel to collect the numbers in 85 Z from all
(or
specified) pages in the workbook and place them on 85 Z on a specified
page.

As you can probably tell, I want to automate a budget report. This has to
be
the kind of thing Excel is made to do, I just don't know what to call it
to
look it up.
--
Thanks!

Collecting data
 

You're welcome.

The formulae will give you the results - not sure why you think you
will need a macro.

Pete

On Apr 19, 9:35*pm, Mary Lee
wrote:
I think so, Pete - I made my examples too truncated, I guess. What you are
saying makes sense. I am trying to gather all of the data totals I need for
each month (one month to a worksheet), then get those results from each
previous month in the same workbook and put them in each month's YTD. Yes, of
course, the results would have to each be in their own cell.

At least I now have a term to search for if I run into trouble when I try to
implement it. I assume I can also do some kind of macro once I get it worked
out?
--
Thanks!



"Pete_UK" wrote:
It's called a conditional sum, and one way of achieving it is to use the
function SUMIF like this:

=SUMIF(M:M,5,N:N)

This does exactly what your second paragraph asks for, and you will put this
formula in cell Z85.

The second part of your post is a bit confusing - you can only have one
formula in a cell, so if you want to get the sum for 10 different numbers
then you will have to have a similar formula but in 10 different cells. The
only difference in the formulae will be the number 5 in the middle.

If you can put the 5 (and 9 other numbers that you are interested in) in
another cell, such as Y85, Y86, Y87 etc., then you can amend the formula in
Z85 to this:

=SUMIF(M:M,Y85,N:N)

and then copy this formula down into the cells Z86:Z94.

Hope this helps.

Pete

"Mary Lee" wrote in message
...
I'm using Office 2003 with Windows XP. I have no idea how to look this up
because I don't know what to call it, but I'm told it can be done.

I'd like to tell Excel (for example) that for each row in column M that
equals 5, then take the number in that same row from column N and add
those
all together and put the total on Row 85 of column Z.

I want to do that for each of more than ten different numbers in column M.

Further, I'd like to tell Excel to collect the numbers in 85 Z from all
(or
specified) pages in the workbook and place them on 85 Z on a specified
page.

As you can probably tell, I want to automate a budget report. This has to
be
the kind of thing Excel is made to do, I just don't know what to call it
to
look it up.
--
Thanks!- Hide quoted text -

- Show quoted text -