Average formula where blank cells are counted as zeros
I am trying to write an average formula that takes into account the blank
I had only cells A2, A4, A6 filled out, but when I do =average(A1:A6), it is
not treating the blanks as zeros so the answer is much higher than it should
Should I do a logic formula within the cells?
If you know the range, you could do the division yourself:
But this would include other non-numeric cells in the count of cells (6), too.
> I am trying to write an average formula that takes into account the blank
> I ha...Using variable names for cells
I seem to remember a technique where I could assign a variable name to
the contents of a cell so that whenever I wanted to use the contents,
all I had to do was call up the variable name. Unfortunately I cannot
find the way to set up the process. Any suggestsions or ideas would be
appreciated. Thanks and a Happy New Year.
Take out the trash to reply
dim rng as range
> I seem to remember a technique where I could assign a variable name to
>...How do I use excel names with INDIRECT with charts
I want to create a Chart that does not directly reference cell-ranges (i.e.
but excel-names that make the reference sheet-independent.
My aim is to be able to copy one chart to other worksheets, which have their
dataareas at the same places like the source-sheet.
Problem: This works fine in cells but not in charts
Excel name definition:
Any idea about this?
Thanks in advance,
You have to include the sheet name in the final formula that you want XL to
www.tushar-mehta.co...SBS2003 + Internet Explorer
We have a customer who has an SBS 2003 Premium server with ISA 2004
They have just installed a bolt on to Outlook which searches their mailboxes
They have discovered that they cannot get this to work unless the untick the
'Use automatic configuration script' in Internet Explorer.
Trouble is each time they re-boot a PC the tick comes back, so sounds like
it's a policy setting somewhere.
What is this ?
Where is it configured and what are the implications of turning it off ?
Could it be that rather than turn it off whatever it is ought to be
con...to extract multiple values from an array
I am into Image processing industry, for each job we create unique
code in excel, we Process 20 jobs in a day, I want to list all the job
Code in "summary of the day sheet" that we complete for the particular
On Dec 30, 4:56=A0am, ratan h <ratha...@nextgenalbums.com> wrote:
> I am into Image processing industry, for each job we create unique
> code in excel, we Process 20 jobs in a day, I want to list all the job
> Code in "summary of the day sheet" that we complete for the particular
> day .
Not enough info but, assuming you are...Am I able to manage multiple email accounts
I have several email accounts including Gmail, HOtmail and corporate. I can't make Entourage mail (2004) list individual accounts or find how to manage profiles. Apple mail works but doesn't allow me to insert a tiff company logo without making it an attachment. Outlook allows for all of the above.<br>
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
On 2/7/08 1...can cvs files be opened using excel viewer
i have a user who cannot open cvs files with excel viewer but can ope
with the full version of excel...anyone experienced this problem and i
so, can you pls post the resolution
darriel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2388
View this thread: http://www.excelforum.com/showthread.php?threadid=37522
There is nothing in the description of the Excel Viewer to suggest that it
can read anything other than true XLS files.
http://support.microsoft.com/default.aspx?scid=kb;...Manufacturing BOM Where Used query
Winthin manufacturing there is a where-used inquiry window that will show all
BOMs that a given item appears in. You can also expand that view to see what
BOMs and item's parent is used in. Some of our BOMs are 10 layers deep.
In our environment we need to know which category of finished goods each
purchased item is used in. Currently we maintain this manually and store the
info in an inventory user-defined field. Over time as the number of our
finished goods and purchased parts has increased this has become an
I need to find a way to query the BOM tables a...Configure single Outlook 2003 Account to try multiple outgoing servers?
Is there a way to configure a single Outlook 2003 account to try
different SMTP servers for Outgoing mail?
I log in from two different locations, and both are behind firewalls.
And from each location I can't get to the other SMTP server to send my
To get around this, I've created two Outlook accounts to use. One for
each location. But this is not a good solution, because I have to
remember to use the correct account, and it's easy to make a mistake.
....When I do, the outgoing mail very quietly sits in my Outbox, and
doesn't get sent. People get very upset at me for ...How to prevent the same program from running twice using vc?
Try this: http://www.codeguru.com/Cpp/misc/misc/article.php/c299
Ajay Kalra [MVP - VC++]
"LeeTow" <firstname.lastname@example.org> wrote in message
Checkout Bob's tip on this subject at
Check Abdoul [VC++ MVP]
"LeeTow" <email@example.com> wrote in message
See also my essay on my MVP Tips site.
On Wed, 8 Sep 2...How do I count the number of times a particular charcter ("." say)
How do I count the number of times a particular charcter ("." say) appears in
For example, ABC.18.104.22.168 should retun 4.
Is there a formula?
(remove nothere from the email address if mailing direct)
"RH" <RH@discussions.microsoft.com> wrote in message
> How do I count the number of times a particular charcter ("." say) appears
> a cell.
> For example, ABC.22.214.171.124 should retun 4.
> Is there ...CRM for international companies
Being an international company, our pricelists are in
different currencies. MS CRM stores the currency on the
Organization level and not on the Business Unit level,
which essentially prevents our use of it.
(1) Any suggestions for a way to overcome this problem
(besides "translating" the EU, EMEA and US pricelist to
one currency, e.g. dollars, or waiting for CRM 2.0) ?
(2) I noticed that the database schema
contains "Organization ID" for all basic tables. This
probably means that multiple organizations can run on the
same CRM server. Currently, I can't se...Utilizing the Print Preview without using a printer
How can I use the Print Preview function and make any necessary changes to my
worksheet?..I currently do not have a printer installed, but would still like
to be able to have access to the Print Preview functions before I actually
print my worksheet.
Just install *any* print driver that might be resident on your system, and
XL will then enable the "PrintPreview" feature, even though no actual
printer is present.
Please keep all correspondence within the Group, so all may benefit!
==========================================...Multiple email accounts #11
I use Outlook 2003 with multiple accounts (4 POP accounts
and one Exchange account) and I have the following
Most of the time I am not connected to the corporate
network, so most of the time I have no connection to the
Exchange server. Because of this Outlook shows the
dissconected icon on the bottom right status bar.
Once Outlook says that it is dissconected from the
Exchange server it doesn't do the automatic syncs with
the POP accounts through the internet (which is indeed
Is there a way to make Outlook autosync with the POP
accounts if it is not conne...Multiple Exchange boxes in one domain
I have the following setup for my domain:
We have a branch office located on another industrial estate 1/2 mile
away, and we currently connect to them via WiFi (11Mb) and they are in
the same domain and subnet as us.
I am looking to add a second exchange box at their site so they can get
their mail "locally". When I look at setting it up tho ot seems that
exchange will still send the messages across the WiFi due to there only
being 1 MX record? Is there a way I can get them to recive their mail
directly over their own Broadband link?
Also ...Microsoft Office X cannot start because MS Office is already in use
Sometimes Entourage 10.1.4 shows the message:
"Microsoft Office X cannot start because MS Office is already in use.
A Office program is being used by MYNAME. Your installation exceeds..."
It's crazy because I'm the only user with OSX (10.3.2) and Office X is
installed only on my Mac!!!
It seems that it happens when Entourage run scheduled actions (i.e. Send
Pls help me.
...Using a value from a cell inside a formula!
I've got two cells that contain the start and end row of a matrix in
I want to use these row numbers in a =COUNT.IF formula to count th
number of specified instances in this matrix.
But my problem is this; how can I use the values in the two cell
inside the COUNT.IF formula??
I should look something like this;
As you can see, the column (F) is specified in the formula but the ro
number needs to be fetched from cell1 and cell2.
Can anyone help me with the correct syntax?
--...Filter to specify which account is used according to email address?
I use outlook for work and personal email but i use two different
accounts to send/recive email. I have run into the problem of
sometimes mistakenly using my personal account to send work emails.
So my question is:
Is it possible to specify that addresses that meet a certain criteria
be send using a certain account. Say an email to Bob@amarc.mil will be
sent using my gmail account whereas a email to Jane@moog.gov will be
sent using a yahoo account?
Any help/suggestions would really be appreciated!
And my question is, what version of Outlook are you using? The answer =
is t...IE crashing when using CRM 3
some users are experiencing a lot of IE crashes when using CRM3.0.5300.0
This is when clicking around the CRM and I have a screenshot of the CRM as
it crashed if anyone needs this...
The diagnostic is below:
<?xml version="1.0" encoding="UTF-16"?>
<EXE NAME="iexplore.exe" FILTER="GRABMI_FILTER_PRIVACY">
<MATCHING_FILE NAME="HMMAPI.DLL" SIZE="38912" CHECKSUM="0xD85D870C"
Can someone please tell me, if someone bought a copy of Pub. 2002 (in a
non-profit org.) and installed it on their machine, could anoher person in
the same building install and use the same copy on their machine under the
license? These two people would be using the program at times but not
constantly - if they never used it simultaniously would it be allowed under
the license? Thanks.
No. (Non-profit status doesn't change anything.)
MVP Microsoft [Publisher]
"Christina" <firstname.lastname@example.org> wrote in message
news:857C024B-CF2D-4CE6-9E28-9AF2E9...I can not use the Templates downloaded from Office Online
My Visio Version is 2002.
I find that the Templates provided on the Office Online are for Office
2003.When I tried to open the Visio templates downloaded with Visio
Any template available for Visio 2002?Where can I get it?
Thanks in advance
Microsoft has an interest in pushing the 2003 content. Perhaps you have a
friend with 2003 that can save them in the older format for you? You might
lose some features of the templates, but it will work to some extent.
Hope this helps,
"�췽" <email@example.com> wrote in message
n...distribution lists sending out multiple mails
This a rather odd problem. My client has a distribution
list setup with about 50 members. Sometimes when he
sends an e-mail through the list some of the members
receive 5 of the same e-mail. This does not happen to all
of the members, only some of them. And the results are
not consistent with everytime he sends an e-mail through
the list. Just wondering if anyone has seen this.
Possibly it's a problem on the recipients end. Any ideas?
I am experiencing the same problem in Outlook 2003 with messages sen
from a bcc list. Did you receive any answers that might be helpful t...CString extension class causes proplems if it's used as an argument in sprintf(...)
I created my own CString class called CMyString which is derived form MFC's
CString. Everything works fine except I use it as an argument in a
sprintf(...) function or each other function which have a variable argument
If I pass an instance of my class CMyString to sprintf(...) I have to cast
it explicitly with (LPCTSTR) or (CString) to get the correct result.
But if I pass an instance of CString I don't have to cast it.
Do anybody know what's going on there?
See my code below:
////////////////////////////////////////////////////////////////////////...Multiple recipients #2
When mailing to multiple recipients, I want only their name to appear, but
once they print, keep each recipients' addresses blocked. How can this be
done without sending to myself and all other recipients a BCC?
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 furious head scratching, stellar asked:
| When mailing to multiple recipients, I want only their name to
var xml = "<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
"<fetch mapping='logical'>" +