count text through worksheets generates error
In a workbook with a lot of worksheets i want to count the number of
times a specific text value occurs in a cell.
All sheets have the same layout.
So, for instance, when i want to count the number of times the value
"yes" occurs in cell B2 through sheets 1 to 5 and i use the function
=countif(sheet1:sheet5!b2,"yes") excel generates an error message (#value!).
I don't understand why, because if i would use the function in 1 sheet
only I get the required result.
I suspect that some functions cannot work on grouped sheets.
Is there a list somewhere that e...How do you make a combination chart with 2 axis.
I'm tring to plot 2 kinds of data. 1 is a % and the 2 is a quanity. How do I
put both on same chart?
Plot them both like they would be using the same Y axis.
Select the one that you want on the secondary axis and format the data
series. On the AXIS tab, you can select a secondary axis.
"smw" <firstname.lastname@example.org> wrote in message
> I'm tring to plot 2 kinds of data. 1 is a % and the 2 is a quanity. How do
> put both on same chart?
...Getting value from 2 cols right, 1 row down
I guess this is a simple question but I couldn't figure out how to ge
A B C D E F
1 Worker 100 100 100 100
2 110 110
3 Worker 120 120 120
4 130 130 13
Sheet above is a work schedule and 100, 110, 120 and 130 are jus
predefined work shifts. Row 1 is a morning shift row and Row 2 is
night shift row for the first worker.
Now what I want to do is to create another sheet with workers names t
m...Chart: 2 lines and a bar
I have searched here and in the help file with no luck.
I see it is easy to have a graph with 2 bars and a line because it i
one of the standards already set up.
But I need 2 lines and a bar and I cant figure out how to do it.
I'm sure it is something easy, but maybe this is a brain cramp o
Kepf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3061
View this thread: http://www.excelforum.com/showthread.php?threadid=50744
Create line chart based on all three set...DPM connection error
I just applied SP1 to my DPM 2007 server. Everything seemed good to go until
I started to update the client agents. After about 10 minutes the DPM server
became very unresponsive. I rebooted it and now when I try to connect to the
Admin console I get an error 'Unable to cnnect to dpm.domain.com (ID: 948)
Verify that the DPM service is running on this computer". I have gone through
all of the services and set them to start automatically and rebooted once
more and I still receive the error.
Any help would be awesome.
Check the status of the DPM servic...Is it possible to have 2 excel version in one computer?
i just installed a 2003 version office... i liked the new features but
when i wanted to open an excel file that has been created by 2002
version excel, i was shocked that i can't open the file successfully.
When i opened and enabled the built in macros in the file, an error
message popped out and said that the data may have been lost. After I
have closed the error message, i checked the file. the data is still in
the worksheet but all the words, format, buttons, and other information
have all disappeared. However, if I open it in another version other
than 2003, the file work...converting sub-reports from Access 97 to XP
I converted a 97 database to XP (without going through
2000) and opened a report containing four subreports.
The subreports seem to have scroll bar arrows and nothing
else visible. I could not click on the subreports
through the main report to open them no matter how hard I
tried. When I attempted to open the same subreports
through the query design window I was told that I could
not open the report again since it was already open. I
was told I would have to click on "view - subreport
through new window." I returned to the main report with
the scroll bar arrows and tri...Can someone help with this error
I am randomly getting an access error in my application and I am trying to
find it. The error seems to occur when allocating a buffer in the CString
code. Does anyone know if the dump below is pointing to anything specific?
It seems like the error is occuring when 'text' is be allocated but I don't
// this is the function call in the ArchExists(..) module where the CString
is allocated (parm1).
CComSetup::ExtractParams( text, &type1, &desc1, &name1, &id1 );
// This is the declaration of the function
void CComSetup::ExtractParams( CString src, CStrin...Outlook 2000 memory error
When I deleted an item in Calendar, I got error message
that "There is not enough memory available to perform the
operation." I am using Outlook 2000.
Thanks in advance.
...HTML formatting #2
One of my clients sends me email in HTML format, but it comes through in
plain text. I tried going to Format>HTML, but all of the options under
format are unavailable in said email.
Can anyone help me?
...Public Folder Permissions #2
I am having trouble removing or deleting old items from public folders
and calendars. Even the Author of the files or events cannot modify or
remove them. The calendar events that are problems were created months
ago. All users have read write permissions for all folders and
calendars.,Some have Editor or Owner and Author rights. However there
are some recurring calendar items that just cannot be removed or
modified by anyone. Even as Administrator with full access rights I
cannot delete these events. I did upgrade from Exchange 2000 to
Exchange 2003 within the last few months but I cannot s...Global error handler
Is there, in ACCCESS 2007, and/or VB a global error handler? I've checked
the docs but not sure on the feasibility of this. I've seen On Error and
OnError, and a discussion excepotion handling, but again, I'm not sure on
the implementation of error and exception handling.
The personal opinion of
Gary G. Little
You must add the error handling to each routine. There's not a way to just
make it automatically go to an exception handler without doing so.
In each routine, you can call a generic error handler. Here's an example of
Error Handling in VBA
...error with the form when using asp.
I get this error, when i submit the form. The error comes up and some
technical advisor from my host company told me to change it to ASP Email but
i don't understand what he was talking about. Can someone provide
Server object error 'ASP 0178 : 80070005'
Server.CreateObject Access Error
/WebAppSub.asp, line 9
The call to Server.CreateObject failed while checking permissions. Access is
denied to this object.
...need help... Getting a error when I add a xml schema include location xsd file
I am trying to add the following line to my xml schema xsd file
Here is my code
XmlSchemaInclude include = new XmlSchemaInclude();
include.SchemaLocation = "../../../Common/datatypes.xsd";
when I print out the schema, it crashes
StreamWriter sw = new StreamWriter(@strFormName+".xsd", false,
Any help is greatly appreciated,
...GP Client install errors
I installed GP 8.0 from a installation template on 1 XP machine with no
problems. I have the ODBC properly setup, and bcp.exe properly
installed to satisfy GP Utilities. I am able to log in with different
users, no problem.
I did the same thing on two other XP machines and both machines give
this Dexterity Runtime error on start-up.
Unable to open dictionary
I get this error for the following .dic's:
EXP1493R....Find and Replace #2
Hello, I am facing a problem regarding finding and replacing, i want to
change a value ":10:20" to "00:10:20". Or in other words just want to add a
leading zero before the colon. I have used the wild card to locate the value
but in replce it chages the value with wild card. Please Help me in this.
Find > Replace > Repl;ace what: :1 Replace with: '00:1 > Replace all
Vaya con Dios,
"Muhammad Hassan (New Excel User)" <Muhammad Hassan (New Excel
User)@discussions.microsoft.com> wrote in message
news:89F2F7DB-4DA9-4823-B572-E9D...excel passwords #2
I need to know how to set up a password and change a
password to prevent access to my workbook.TIA
Use workbook/sheet protection.
Select tools menu>protection. There you can select the
type of protection you want and include a password
>I need to know how to set up a password and change a
>password to prevent access to my workbook.TIA
...Migrate Contact Address Data from CRM 1.2 to 3.0
We are upgrading from CRM 1.2 to CRM 3.0. In order to migrate the existing
data, we are using the CRM web services (in "../crmservice.asmx"). CRM 1.2
stores the contact data in the ContactBase table; I create a data source,
create an instance of the "contact" object from the CRM web service, set each
of the contact properties from the field values in the DataRows of the
DataSet source, and then use the contact object's Create() method to add each
contact to the CRM 3.0 database -- all of this works very well.
However, CRM 1.2 stores the contact's address d...Publisher file #2
I am preparing (as I do every month) a magazine formatted in booklet style.
Whenever I close and reopen, it's turned itself into a web page! I can
reconvert it via Page setup, but when I return to work some more, it's back
in web page format. Any idea why? and what can I do to stop it, please?
Protected by Norton Antivirus
What version Publisher?
Mary Sauer MS MVP
"Lorna Dodd" <email@example.com> wrote in message
news:ulvrWxi...SMTP authentication #2
I have the Office XP (2002) Small Business Edition (it
came with my Dell PC). My Internet provider requires that
I check the option "My outgoing server (SMTP) requires
authentication" in the Internet Mail settings. I check
that option, but when I close Outlook and reopen it, that
option is unchecked. I have reinstalled the Office XP SBE
twice, updated it with all the updates offered in
Microsoft Office Web Page but the problem persists.
This problem started after I formatted the hard disk
because the PC was too slow. Before there was no problem.
Also some of the windows to ...Order Entry #2
We have set up a password to allow price changes when entering orders
because we don't want to allow everyone access to this field. I have three
customers that request the password even when the salesperson isn't trying
to change the price. I have checked the customer cards of these companies
and I can't figure out why these three produce this message. Is there
something in particular I need to be looking at?
What's the exact message you are getting? Are you sure you are not being
prompted to override price below cost?
Mariano Gomez,...return a zero for error
I'm having a problem with a spreadsheet I'm developing which records average
marks of groups of students over several weeks. I want to display a
"Running Average" of those averages as I enter the data, however, because I
do this week by week there are inevitably weeks which have not had any data
entered and her I see the error #DIV/0! for the formula
=AVERAGE(IF(R5:R20<>0, R5:R20,"")). I do understand why I'm getting this
(because I'm dividing by zero) but would like to return a zero so that the
average of the averages will return a number rather tha...Money Investment Toolbar Error
All of a sudden, whenever I try to access my portfolios in the Deluxe
version, I get this error: AppName: iexplore.exe, AppVer: 6.0.52800.1106,
ModName: myisam05.dll, ModVer: 4.0.3107.50512, Offset: 00006e27.
I can remove the Toolbar and use the basic portfolio version but continue to
get the above error and an IE restart whenever I try to upgrade to Deluxe.
In microsoft.public.money, Dencoden wrote:
>All of a sudden, whenever I try to access my portfolios in the Deluxe
>version, I get this error: AppName: iexplore.exe, AppVer: 6.0.52800.1106,
>ModName...XML serialization problem #2
I'm a .NET beginner and I've got a problem on a program where I try to do an
I get the following error :
"An unmanaged exception of type 'System.IO.FileNotFoundException' occured in
Additonal information : the file or asssembly named n9gu4-bo.dll or one of
its dependencies cannot be found"
Here is the code :
(I've uploaded the complete project at this url
public class Form1 : System.Windows.Forms.Form
TextReader reade...HTML Signatures #2
We are creating signatures for all employees and using a
template it has to be html, can't use a simple GIF. Is
there a way to embed the graphic into the html file or
into the e-mail itself so whenever it is sent it isn't
being sent as an attachment?
You can use a little bit of CGI as part of the employee's signature.
This CGI can retrieve the HTML from a Web server. For instance, you
could have a signature like: