[mso] Re: Excel question.
- From: "Srinivasan Seshadri" <sesh918@xxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Fri, 24 Nov 2006 06:55:16 +0300
Dallas Stearns,
Your best bet would be to go to
mrexcel.com or
videoprofessor
While videoprofessor takes you step by step through its CD ROM, mrexcel tips
and tricks are excellent.
best of luck
Srinivasan Seshadri
On 11/22/06, Dallas Stearns <dallas_1973@xxxxxxxxxxx> wrote:
>
>
> Dave,
>
> You rock! I think that will work. I will have to wait tilli get back to
> work- because I left it on my work computer. I'm in my Excel infancy- so
> I
> appreciate everyone's feedback. Any suggestions on how I can enhance my
> learning of Excel? I have thought about taking some classes on it. I do
> learn things like this better hands on- and if someone is there to
> "bounce"
> questions or ideas off of. Anyhow- Thanks everyone for their help!!!!
>
> I can only hope that I can help when any of you need help as well!
> Dallas Stearns
>
> ----------------------------------------------------------------------------
> From: "David Smart" <smartware@xxxxxxxxxxxxxxx>
> Reply-To: mso@xxxxxxxxxxxxx
> To: <mso@xxxxxxxxxxxxx>
> Subject: [mso] Re: Excel question.
> Date: Wed, 22 Nov 2006 22:37:51 +1100
> >Your attachment didn't make it, so ...
> >
> >By "running total", I assume you want a totals column, with a figure on
> each
> >row, where that figure is the sum of all the sales by that person down to
> >that point.
> >
> >For instance
> >
> >
> >3310 100 100
> >3310 127 227
> >3303 86 86
> >3310 875 1102
> >3310 887 1989
> >3303 352 438
> >3303 34 472
> >3310 762 2751
> >3310 634 3385
> >3303 234 706
> >3303 412 1118
> >
> >
> >
> >Where the first column (A2:A12) has your person number. The next column
> >(C2:C12) has the individual sales amounts. The last column (E2:E12) is
> the
> >intermingled running totals for the two people.
> >
> >This can be done with an anchored SumIF. For instance, E10 is
> >
> >=SUMIF(A$2:A10,A10,C$2:C10)
> >
> >The trick is having the anchor on the top (Row 2) items, but not on the
> >bottom of the range (Row 10 in this case). You can copy/paste this
> formula
> >all down the E column to give you an interspersed running total column as
> >tall as you want.
> >
> >Note that it is not limited to just two people. It can easily handle
> more.
> >For instance, just changing a couple of Column A numbers:
> >
> >3310 100 100
> >3310 127 227
> >3303 86 86
> >3300 875 875
> >3310 887 1114
> >3303 352 438
> >3303 34 472
> >3310 762 1876
> >3300 634 1509
> >3303 234 706
> >3303 412 1118
> >
> >
> >gives you the extra person: 3300.
> >
> >Regards, Dave S
> >
> >----- Original Message -----
> >From: "Dallas Stearns" <dallas_1973@xxxxxxxxxxx>
> >To: <mso@xxxxxxxxxxxxx>
> >Sent: Wednesday, November 22, 2006 9:33 AM
> >Subject: [mso] Re: Excel question.
> >
> >
> >>
> >>I will attach one of the reports. The A/M is short for account manager-
> >>there are two that I deal with- one with the number 3310, and the other
> >>3303. The column next to that number is the OTB (short for ONE TIME BUY-
> >>which is a term when a client comes in and purchases only one item that
> >>may
> >>have been left off the inital order) The A/M still get's credit for it-
> >>but
> >>my company doesn't track it- I have to. So i have 2 A/ms and for each
> OTB
> >>i
> >>have to keep a running total. In the spreadsheet i sent- i have been
> >>MANUALLY entering these values. I know that there has to be a way I can
> >>makeit do it for me. That's why i asked the group. I color coded them to
> >>show you what I mean. I have to arrange this by date- otherwise it would
> >>be
> >>easy to do what I want if I could arrange by account manager.
> >>
> >>Thank you soo much. ALSO- where can I find your book on excel?
> >>
> >>Dallas
>
> >>--------------------------------------------------------------------------
> --
> >>From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
> >>Reply-To: mso@xxxxxxxxxxxxx
> >>To: <mso@xxxxxxxxxxxxx>
> >>Subject: [mso] Re: Excel question.
> >>Date: Tue, 21 Nov 2006 17:10:44 -0500
> >>>I'm assuming their number appears on each row that shows their sales?
> And,
> >>>that the number is always in the same column?
> >>>
> >>>You can sum all the sales that refer to each salesman's number, either
> by
> >>>creating a table and using the DSUM function, but it might be easier to
> >>just
> >>>do it as an array formula.
> >>>
> >>>Read this article I wrote on array formulas and see if this gives you
> what
> >>>you need:
> >>>http://personal-computer-tutor.com/arrayformulas.htm
> >>>
> >>>You need to see the part which shows you how to sum something in Column
> A,
> >>>based on what is in Column B
> >>>
> >>>
> >>>Linda F. Johnson
> >>>Linda's Computer Stop
> >>>Author, MOS: Excel 2003 Study Guide, published by John Wiley and Sons
> >>>http://personal-computer-tutor.com
> >>>
> >>>-----Original Message-----
> >>>From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
> Behalf
> >>>Of Dallas Stearns
> >>>Sent: Tuesday, November 21, 2006 3:50 PM
> >>>To: mso@xxxxxxxxxxxxx
> >>>Subject: [mso] Excel question.
> >>>
> >>>
> >>>ok, I'm having an issue. I have tried everything I can think of-
> hopefully
> >>>someone from this news group can help. I have a pretty simple excel
> >>>spreadsheet. It's a sales tracking form. I have 2 sales reps that are
> >>>assigned a number to identify them (one is 3310, and the other is 3303)
> >>>
> >>>I track all the sales they make. AND in the LAST column there is a
> >>>"running
> >>>total" from each rep. I have tried an "If" formula- and I can't make it
> >>>work. Is there something someone might be able to suggest. I don't want
> >>>thetotal to be the TOTAL sales- but rather a running total from each
> rep.
> >>>
> >>>
> >>>
> >>>thanks! Dallas
> >>>
> >>>
> >>>*************************************************************
> >>>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, visit the group's homepage and use the
> >>dropdown menu at the top. This will allow you to unsubscribe your email
> >>address or change your email settings to digest or vacation (no mail).
> >>>//www.freelists.org/webpage/mso
> >>>
> >>>If you are using Outlook and you see a lot of unnecessary code in your
> >>emailmessages, read these instructions that explain why and how to fix
> it:
> >>>http://personal-computer-tutor.com/abc3/v28/greg28.htm
> >>>*************************************************************
> >>
> >>
>
> >>--------------------------------------------------------------------------
> --
> >>Talk now to your Hotmail contacts with Windows Live Messenger.[1]
> >>
> >>--- Links ---
> >>1 http://g.msn.com/8HMAENUS/2749??PS=47575
> >>*************************************************************
> >>You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxxxx
> >>MicrosoftOffice@xxxxxxxxxxxxxxxx
> >>
> >>To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
> >>
> >>To Unsubscribe from this group, visit the group's homepage and use the
> >>dropdown menu at the top. This will allow you to unsubscribe your email
> >>address or change your email settings to digest or vacation (no mail).
> >>//www.freelists.org/webpage/mso
> >>
> >>If you are using Outlook and you see a lot of unnecessary code in your
> >>email messages, read these instructions that explain why and how to fix
> >>it:
> >>http://personal-computer-tutor.com/abc3/v28/greg28.htm
> >>*************************************************************
> >>
> >
> >*************************************************************
> >You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxxxx
> MicrosoftOffice@xxxxxxxxxxxxxxxx
> >
> >To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
> >
> >To Unsubscribe from this group, visit the group's homepage and use the
> dropdown menu at the top. This will allow you to unsubscribe your email
> address or change your email settings to digest or vacation (no mail).
> >//www.freelists.org/webpage/mso
> >
> >If you are using Outlook and you see a lot of unnecessary code in your
> emailmessages, read these instructions that explain why and how to fix it:
> >http://personal-computer-tutor.com/abc3/v28/greg28.htm
> >*************************************************************
>
>
>
> ----------------------------------------------------------------------------
> Get the latest Windows Live Messenger 8.1 Beta version.Join now.[1]
>
> --- Links ---
> 1 http://g.msn.com/8HMBENUS/2746??PS=47575
> *************************************************************
> 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, visit the group's homepage and use the
> dropdown menu at the top. This will allow you to unsubscribe your email
> address or change your email settings to digest or vacation (no mail).
> //www.freelists.org/webpage/mso
>
> If you are using Outlook and you see a lot of unnecessary code in your
> email messages, read these instructions that explain why and how to fix it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> *************************************************************
>
*************************************************************
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, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
