Conditional Sum Problem
I have three columns of data something like this:
A B C
1 Balance Report Product Type
2 3,000 Y Oranges
3 1,000 N Oranges
4 4,000 N Apples
5 500 Y Pears
6 2,500 N Pears
7 8,000 Y Oranges
Range A2:A7 is named "Balance", B2:B7 is named "Report" and C2:C7 is named
I am trying the following:
=SUMPRODUCT((Balance)*(Product_Type="Oranges")*(Report="...Outlook 2003 #215
I was wondering how to get rid of the apostrophe around a
name(email address) in my sent items folder. The
apostrophe puts my emails out of order and makes it
difficult for searching for a past email.
...Xml Attribute..id problem??
I have an xml file as below
<table id =1>
<table id = 2>
What I want is this id attribute to increment automatically.
So I declared it of type "ID" ..but how do i access the value of this
When i add a record it gets added to the xml file but the id attribute does
not show..So how do i refer to this attribute.
> What I want is this id attribute to incre...Ports for Outlook on Exchange
We are about to move our Exchange server onto a different VLAN from the
workstaions. The server VLAN will have ACL. Not sure what ports we need to
allow on the ACL for the Outlook clients. Any ideas.
Thanks in advance.
YOu would do better to post this to an Exchange group -
microsoft.public.exchange.admin would be a good place for this.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, dc asked:
| We are about to move our Exc...select * from #temp problem in HQ
Hello I have a client who Every time he tries to enter he has the
following error: "name of the the object #temp not valid select # from
#temp where [status] in (0,1,2,3,4,5,6,7)" According to him he didn't
do anything unusual just locate the server outside the office.. any
suggestions? Thks in advance for your time
This is a multi-part message in MIME format.
Search for any QS*.tmp files on the hard driv...Outlook Express #245
My time stamp on incoming messages is way outta wack. Has
anyone encountered this issue or know how to fix this
problem? Any feedback would be appreciated.
Mark <firstname.lastname@example.org> wrote:
> My time stamp on incoming messages is way outta wack. Has
> anyone encountered this issue or know how to fix this
> problem? Any feedback would be appreciated.
Ask in an Outlook Express newsgroup.
We are using IM with GP10. While the integration was running against the SOP
window, my system got hang were i need to restart my machine. After restart,
while i run my IM against the SOP window it states an error message to close
the GP window which was open. But there were no window kept to be open.
As far as i had concern, since IM was closed abruptly it had kept the same
window open and not yet closed it.
Can any one help me put to overcome this problem and to run the integration
against the same window.
Make sure you have installed the latest service packs for GP a...On Shutdown
How does windows or how can I signal my View when the user has clicked the
X or selected Exit on the Mainframe menu?
Thanks as always!
www.Newsgroup-Binaries.com - *Completion*Retention*Speed*
Access your favorite newsgroups from home or on the road
What do you mean?
If you want to close the window then send it a WM_CLOSE message.
If you want to exit the application all together, then use
"Ron H." <email@example.com> wrote in message
> H...problem with verdana font???
I have an excel file which I've used for a while. When I opened it up
today I couldn't see any of the text on the worksheets. I tried to
change the font colour and size etc, but it seems excel doesn't find
the verdana font. I can see the text if i change the font to tahoma for
Does anyone know why this might happen? If i type anything in verdana
the whole row just blanks.
...Extra Carriage Return Problem
I am using XML XSL to create a CSV file using Transformation. But during the
transformation all the Newline characters (CHR 10) is getting translated to
Carriage Return and New Line (CHR 13 and CHR 10) causing problems in the
Is there are any way to resolve this issue?
...dll registration problem
I have dll build on XP with unicode, and it doesn't want
to register on Win98, but when I built that code on 98
it registered. Do somebody now simple solution to
make it work when built on XP? any switch or something?
"zorman" <firstname.lastname@example.org> wrote in message
> I have dll build on XP with unicode, and it doesn't want
> to register on Win98, but when I built that code on 98
> it registered. Do somebody now simple solution to
> make it work when built on XP? any switch or something?...Worksheet protection problem
I am using Excel 2000, wanting to protect certain cells, but allow user to
filter using autofilter, etc. and how would I do this?
Private Sub Workbook_Open()
Worksheets("Sheet1").EnableAutoFilter = True
Right click on the Excel icon next to File in the menubar
choose view code
paste the code
Alt-Q to go back to Excel
This runs every time the workbook opens. It protects the worksheet and
allows users to use the AutoFilter dropdown lists.
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002...Favorites problem returned
I thought it was fixed, but I guess it wasn't. So I took Bob's advice and
ran regedit and took out the word downloads and voila... it seems to be
working right, for sure now.
The new problem is Everything in my favorites list appears to be on the
Favorites Bar as well. How do I get them all off there, leaving them just on
the list and a select few on the bar?
On Thu, 15 Apr 2010 10:37:34 -0400, "sandy" <email@example.com>
>I thought it was fixed, but I guess it wasn't. So I took Bob's advice and
>ran regedit and took out the wo...Outlook 2003/2007 won't save password
I was using Outlook 2003, but started having a problem with my email password
being saved. I went to the Microsoft website for help and tried all the
resolutions of KB290684. Tried to create new profiles, run in safe mode, and
delete registry key. No luck on any.
I upgraded to Office 2007, in hopes that this would solve my problem, but I
have the same issue. So now, I have Outlook 2007 and it will not save my
I believe this may be a OS issue as having the same issue with an RDP
Looking for any help.
Are you running an AntiVirus application setup to scan yo...Read Only Problems
WinXP Home on PC and Laptop
Excel 2002 on PC and Excel 2003 on Laptop
Home PC used to store documents.
When using laptop to retrieve Excel files over home network,
all files, when opened, are marked READ ONLY.
When those same files are pulled up on PC,
they ARE NOT read only.
> WinXP Home on PC and Laptop
> Excel 2002 on PC and Excel 2003 on Laptop
> Home PC used to store documents.
> When using laptop to retrieve Excel files over home network,
> all files, when opened, are marked READ ONLY.
> When those same files...Reset an Outlook 2003 Profile
My platform is as follows:
Windows 2003 Server SP1
Exchange Server 2003 SP2
Outlook 2003 clients
I have a few issues dealings with Contacts in the Outlook client of one
He had a Contacts folder with sub-folders. We deleted this contacts, and
sub-folders as well, to move them to somewhere else (in a Public folder, in
order to share them with other users).
The issue is that when this user creates a new message, by doing New
Message, and then clicking on the TO: field, the Contacts sub-folders are
still visible - but empty of course, and popping a warning whenever you try
to selec...Problem with Sumproduct when some cells are null
I am having a problem using Sumproduct when some of the cells have
null values. I will try to describe the problem. Please let me know if
you need additional information. Do any of you have any ideas of how I
can fix that sumproduct to get it to work?
A B C
Emergency 81.68% $24,444
Emergency 35.00% $164,758
Emergency 35.00% $215,237
Emergency 22.73% $105,059
Emergency 8.46% $53,760
Goal is to calculate an aggregate trend for the Emergency Category
excluding those rows that a...outlook express #230
I'm also receiving within the error message that the
message cannot be sent because of too many recipiants.
How can I delete the message so my system will no longer
try to send the message? I would simply go into my
outgoing mail box but it's empty.
...Shutdown-difference between Shutdown and Reboot
does anybody knows what is the difference between the real shutdown
and the shutdown which is part of a reboot?
I have a problem with an XP SP3 Computer, when i try to shutdown, it
doesn't, but when i reboot, it makes the complete shutdown and
The problem is caused by an external HDD, without it, the shutdown of
the machine is ok.
Now i would like to take the shutdown-command of the reboot, if that
Thank you, Regards, franc
> does anybody knows what is the difference between the real shutdown
> and...OWA 2003 problem #2
We have been using Exchange 2003 with OWA for about a year now without
any errors. Friday when users tried to connect they are able to log in
fine, but instead of seeing the typical OWA interface all they get is
some frames, with a bunch of Red x box graphics, and test for inbox,
calendar, etc. When clicking on the text nothing happens.
The only change that was made to the system were to recent updates from
microsoft for January....
...Problems after applying windows update KB 960715
My company is using MGP ver 7.00. Recently we applied windows update KB
960715. After which we have some problems with some of our VBA applications
which are called within MGP. One of the problems was that the date field has
been disappeared from the entry screen. When I try to edit the form in
TOOLS-CUSTOMIZE-VISUAL BASIC EDITOR, I realized that I was unable to format
the text box as 'dd-mm-yyyy' format. It seems that the activeX is not
working. What should I do now?
Thanks for your help.
The solution you require is described in the following article:
http://blo...Timer Problem on Close
I am currently working on a MDI application and have this problem: I
have start a timer with SetTimer( 1, 100, 0 ) in CMainFrame. Then when
I close the window, a runtime error occurs, forcing the whole
application to exit. I tried to add KillTimer in ChildFrm OnClose,
WM_DESTROY and destructor, but the problem still persist. Can someone
please help? Thanks!
> I am currently working on a MDI application and have this problem: I
> have start a timer with SetTimer( 1, 100, 0 ) in CMainFrame. Then when
> I close the window, a runtime error o...Outlook 2002 hangs on shutdown
Outlook 2000 hangs at the "Please wait while Microsoft
Outlook exits". I read Microsofts Knowlege Base Article -
834005 that list a Hot fix for the problem but their is no
link to the file to down load. Can anyone help me find
the file. Thanks
You need to contact Microsoft Product Support Staff for Hot Fixes - they are
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.g...Outlook 2003 emails sent in future. How do I resend them with corr
My outlook 2003 sent many emails with a future date - 1 month in future. I
reset the server clock. Now, I need to know if I have to resend the emails
with corrected date (and annoy the receivers) or can I somehow change the
send date? This is for record keeping on my end. Cover My arse.
It shows that although the send date is 1 month in future, they received the
email with the incorrect date.
...Problem copying data to a test environement
I'm trying to create a new test environment from our Production
environment. I've used the User export wizard and the redeployment
But every user in the database still references the old domain user (in
the DOMAINName of the systemUserBase table) Is this normal? I tought
that by creating a child domain of my domain, the wizard would use my
Now some part look to be working but as soon as I try to open a record
(account, contact, use, etc) or create a new one, I get the "An error
has occured, consult your domain admin..." message...
In the ev...