[mso] Re: Excel help
- From: "Andrew" <tyto2820@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 16 Aug 2004 19:32:18 +0100
In this case I would either use a pivot table or the SUMIF function.
If using the SUMIF function, I would make a separate table to the side of
the data or on another sheet, with the months in one column, shall we say in
AA2:AA13 and a formula something like the following next to each month in
AB2:AB13 (assuming you intend to have, say 100 rows of main data and that
row 2 contains the headings):
In AB2: =SUMIF($A$3:$A$103,AA2,$G$3:$G$103)
This says:
Sum all the values in the range G3:G103 where the corresponding value (text)
in A3:A103 is equal to the value (text) in AA2
Replicate this formula down thru AB13 (notice that the two ranges are
absolute but the criterion will change to be the appropriate cell in AA).
If you were to name the ranges in the data set as "Month" and "Amount", you
could type =SUMIF(Month,AA2,Amount)
Andrew
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx
> [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Scott-Johnson,
> Tiffani D.
> Sent: 16 August 2004 18:58
> To: Formula help (E-mail)
> Subject: [mso] Excel help
>
> There is a spreadsheet that keeps information for July to the
> next July.
> A2 month B2 Org C2 Appropriation D2 Account E2 Handling
> F2 Freight G2
> Amount
>
> Since I would like the one spreadsheet to go for one year I
> am not sure how I could code this to add up the information
> in F2 and give one total and G2 to give one total based on
> each month in A2. So I would like it to know if I go to the
> next month in A2 that means it should start a new calculation.
>
> Any ideas?
>
>
>
>
>
>
>
> Tiffani Scott-Johnson
> Administrative Assistant
> Tesoro Refining and Marketing Company
> Phone: 801-521-4870
> Fax: 801-521-4803
> TScott-Johnson@xxxxxxxxxxxxxxxxxxx
>
>
>
> *************************************************************
> You are receiving this mail because you subscribed to
> mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, send an email to
> mso-request@xxxxxxxxxxxxx with the word "unsubscribe"
> (without the quotes) in the subject line.
>
> Or, visit the group's homepage and use the dropdown menu.
> This will also allow you to change your email settings to
> digest or vacation (no mail).
> //www.freelists.org/webpage/mso
>
> To be able to use the files section for sharing files with
> the group, send a request to mso-moderators@xxxxxxxxxxxxx and
> you will be sent an invitation with instructions. Once you
> are a member of the files group, you can go here to
> upload/download files:
> http://www.smartgroups.com/vault/msofiles
> *************************************************************
>
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
