[mso] Re: Excel question.
- From: Graham Jones <agjones@xxxxxxxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Wed, 22 Nov 2006 11:40:34 -0000
Hi Steve and Dallas
Please note that attachments do not get through the mail to MSO, so you =
will
need to contact each other direct to exchange items.
Pity because I like to follow problems and keep track of solutions for =
new
ideas, so would appreciate if you copied me in when/if you do!
Hope I've got your addresses right - all the best
Graham
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On =
Behalf
Of Steve Moghaddam
Sent: 22 November 2006 01:59
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel question.
If I do not want to use VB then the way I do it is very simple. I =
create a
criteria containing sales rep name on sheet2, then create a data range =
on
sheet1. At the bottom or top of the sheet1 using DSUM function, I get =
the
running total of each rep. See the attached example. I hope this will =
help.
Thanks
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On =
Behalf
Of Dallas Stearns
Sent: Tuesday, November 21, 2006 1:50 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Excel question.
=20
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. =20
=20
thanks! Dallas=20
------------------------------------------------------------------------=
----
Get the latest Windows Live Messenger 8.1 Beta version.=A0Join now.[1]=20
--- Links ---
1 http://g.msn.com/8HMBENUS/2746??PS=3D47575
*************************************************************
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
*************************************************************
-- No attachments (even text) are allowed --
-- Type: application/vnd.ms-excel
-- File: DSUM.xls
*************************************************************
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:
