Hi. Hope you’re able to help. I’m having difficulties the SUMIFS function.
Either I’m using it incorrectly or perhaps it’s the wrong function for me!
I’m trying to total the money amounts in column E as long as conditions in
columns A (cell A6 in this example) and column H are True. However, I’m
finding that the function is not totalling up the money amounts it should be
totalling in column E. Instead, it’s just returning a single money amount in
column E and ignoring the rest! This is the function as I’ve written it:
=SUMIFS(BnkChqs!E3:E1000,BnkChqs!A3:A1000, A6,BnkChqs!...newbie needs help
First to let you all know, I am a big novice at this kind of stuff, so
please bear with me.
What I am trying to do is make a trendchart with 9 different plots on it.
How do I change the numbers on the side and bottom of the chart to read what
I need them to? I take these tests 3 times a week and would like to chart all
of them seperately and also together to chart progress for a whole month.
One for each day, and then one for the month. Then I would like to do the
same for the following months of the year. And I would like to have one chart
to show the progress for the whole...When converting MDE
Assuming most people aready have Office 2000, so I want to create an MDE . I
understand we should use Access 2000 to make MDE.
Since I do have Access 2002 or Office XP, how can I make MDE ver.2000
The other question, suppose I have Access 2000 and I successfully made MDE
ver200, can this MDE be opened by Acess 2002 and higher?
H. Frank Situmorang
You must have Access 2000 to create an Access 2000 MDE.
Yes: an Access 2000 MDE can be used in all later versions.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/ti...How can I convert text to all lowercase?
How can I convert text to all lowercase?
I know that I can use the Format menu to convert a block of text to all
uppercase, but is there any way to convert it to lowercase?
If not with Excel, how about Word, DOS, any other way.
I'm using Excel 7.0 (Office 95).
Thanks in advance!
Take a look at David McRitchie's Lower() Macro (I believe it will
work in XL7):
In article <firstname.lastname@example.org>,
email@example.com (HBYardSale) wrote:
> How can I convert text to all lowercase?
&g...Help! Unable to mount public folder store event 9519
I am getting the following error when tring to mount the public folder store.
Event Type: Error
Event Source: MSExchangeIS
Event Category: General
Event ID: 9519
Error 0x8004010f starting database "First Storage
Group\f7967383-856a-4b7f-9023-37c269a0e908" on the Microsoft Exchange
Look up of DB Info failed.
For more information, click http://www.microsoft.com/contentredirect.asp.
I have tried numerous ms kb articles to no avail.
I did find this on a news group :-
I'm looking for help some help with a formula.
How would I go about a formula for automatically adding 8 hours to a
number each calendar month? I would like to open it and have it done for
me if that's possible rather than having to remember to add it each
month or forgetting if I did or not.
For instance, i start out with the # 248 in a cell that I would like to
automatically add 8 to each calendar month.
"Gadgetman" <firstname.lastname@example.org> wrote in message
> I'm looking for help some help with a formula....Converting decimals to Time
For thousands of rows, time has been entered as 10.15 or 9.30. These are
correct times, as in quarter-past-ten and nine thirty. To perform
calculations, I obviously need to have a : (semi-colon) not a . (full-stop)
Find and replace won't work because 9.3 (nine thirty) comes up as 9:03.
I can write a macro, but trying to avoid since it's for someone else.
Microsoft MVP - Excel
"Piers 2k" <email@example.com> wrote in message news:uTDz539DHHA.1748@TK2MSFTNGP02.p...need document properties statistics revision information
using excel 2000 pro
in document properties; statistics tab; bottom half of info i do see "last
saved by" info but cannot find help on how to get the "revision number" and
"total editing time" information.. can anyone help me with this.. I would
like to set it up so that it is automatically entered for every document i
create and not have to recreate for every file.. thanks
...I need help with a formula
I'm making a stock list sheet and I like to put on it the value - and +
like when I take boxes out it will give me the total and when I add in
it will change also.
This is for a weekly count.
I'm very new to excel so please H-E-L-P-.
I need the instruction like u give it to a child. :) :)
Thanks a lot
pampam's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26224
View this thread: http://www.excelforum.com/showthread.php?threadid=395241
We need ...formula help 02-10-10
Would like to accomplish:
How do I add number 2 infront of the above ISSUE numbers as I have thousands
of line to do.
If your number is in column A then in column B type
=2 & A1
and copy it down.
Please rate when your question is answered to help us and others know what
> Would like to accomplish:
> 2...Thunking a 32-bit HANDLE to a 64-bit HANDLE
Currently I am converting a 32-bit WDM driver to a 64-bit KMDF driver that
will continue to work with our 32-bit DLL and our customer's 32-bit
The sample code for thunking 32-bit items shows the following
Buffer->Handle = (HANDLE)Buffer32->Handle;
Buffer32->Handle is declared as UINT32 Handle
The driver compiler issues error number C4312 for this cast. The code that
I have adopted (to get it to compile) is:
handlerInputs.hEvent = (HANDLE) (ULONG_PTR)
p_handlerInputs3...Convert Publisher letterhead to Word
How do I convert my letterhead creaded in Publisher to Word or other word
processing software, e.g., OpenOffice, so that I may create text in the
letterhead to email to clients/customers? You may reply privately to
firstname.lastname@example.org if you wish. Thank you.
Right-click the creation, save as picture.
This tutorial is perfect for what you want to do
"JoOffice" <JoOffice@discussions.microsoft.com> wrote in message
> How ...can't convert jpg or other into publisher
I reinstalled publisher after reformatting my xp Dell. Now publisher will not
convert image into the page where I want a picture. I can scan one in, but
can't import clip art or a picture located elsewhere. I can import a picture
into word. I reinstalled publisher again and same thing. I put it on a
friends computer and everything works fine - I'm puzzled. What are they
referring to when it's saying can't convert the image - also mentions a
I need help.
Importing from where? Are you using the Clip Gallery or Organizer?
If you are trying to import ...Excel and Calendar Control 8.0
Enter an Excel worksheet. Click Insert, select Object and then,
Calendar Control 8.0.
Now, the Calendar is shown on the worksheet. And then, the worksheet
operations is finished with the Calendar.
Please say, how to remove the Calendar from the worksheet.
...sql replication on GP 8.0
I was wondering if it is possible to setup replication on the Great
Plains db's ie Dynamics and the company databases? If so which replication
method does anyone suggest? Thanks in advance.
I have tried this before, and I don't think it's possible. The replication
adds a column to every table (I forgot the name, but something like
Replication ID). This messes with the stored procs that dexterity uses to
read the tables.
> I was wondering if it is...Need Exchange limit help
I have a new SBS 2008 Server setup in a manufacturing environment. Two
users within the company send and receive large CAD files. How do I allow
this process? Right now one user is try to send a 185MB file and it is
saying "the message being sent exceeds the message size established for this
user." I have tried setting the limit in the console to 10GB and now I have
unchecked the "enforce the mailbox quotas" box and he still can't send. If
I go into the Exchange Management Console I still don't see how I can make
this work. Is this something that...Combining 2 Text Strings in Body of E-Mail Q
I am trying to create a string of text to place in the message body of
an e-mail. Using Ron De Bruins code I've run in to the "Too many line
continuations". I've a requirement for 31 lines, but it hits this
error on line 24. How can I combine 2 text strings to appear in the
message body of the reports. My code with only the first stringbody
Dim FileExtStr As String
Dim FileFormatNum As Long
Dim Sourcewb As Workbook
Dim Destwb As Workbook
Dim TempFilePath As String
Dim TempFileName As String
Dim OutApp As O...How to Insert brackets within string
In my worksheet, I have two columns, Col A for users to enter projects
numbers while Col B for work description and Col C for cost spent. The
project numbers and cost are then collected into pivot table in another
workbook for other calculation.
The problem now is some of the project numbers are like this 1100,
1100(A), 1307(E), 1611(A), 1611(B), 1612(C), 1612(D), 10303(1) and
So, if the users enter 1100A instead of 1100(A), then I cannot do the
caluculation correctly. If the user enter 1100A mistakenly, Can we do
some code to change it to 1100(A) ? using IF-else maybe or ??
Please ad...Convert Word Table -> Excel without merged cells?
Whenver I copy/paste tables from word to excel, I get merged cells in
Excel whenever there are line breaks in the word table cells. How can
I avoid this?
Saved from a previous post:
If your cells in your word table contain paragraph mark or linebreak characters,
then excel will bring them over as separate cells.
One way around it is to convert those paragraph marks & linebreaks to unique
characters, then copy|paste and then convert them back to linefeeds.
I like this technique (inside a copy of the word file):
Select your table.
Edit|replace|Special (show More if required)...Converting an Excel List into Access
I am unable to import a specific excel document into
Access. I have done countless other imports and never
encountered an error. What are some possible reasons for
being unable to import the file?
Yes all that shows up is: "An error occured while trying
to import(directory path here). The file was not imported"
>What happens when you try to import it? Is there an error
>> I am unable to import a specific excel document into
>> Access. I have done countless other imports and never
>> encountered...Help with Hurricane Database
I work at the Corporate office of a fast food chain. We have almost 1000
stores in 10 states - mostly in the South. We have many stores in the
hurricane zones. During Rita and Katrina we decided we needed a better way
to track how our stores are affected and what help we could provide. I've
designed a database to do this.
I have three main tables:
fldUnit - the unit number assigned to the store
fldPr...Converting 97 Outlook Notes to Outlook 2003
Help! Where have our notes gone? We've just converted
from Outlook 97 to Outlook 2003 and all of our notes
disappeared. Where did they go and how do I get them to
convert to 2003?? Thanks!
...converting firgures in words and vice versa
if i have stored a figure in one and in other cell i want to get that figure
in words is it possible if yes then how as well as vice versa.
Look here for one way traffic:
I've never seen it the other way around
Microsoft MVP - Excel
"nitesh" <email@example.com> wrote in message news:88B02773-0F9F-4963-A284-F75D48A9DAE7@microsoft.com...
| if i have stored a figure in one and in other cell i want to get that figure
| in words is it possible if yes then how as well as vice versa. ...Outlook Certification Help
Do you need additional proof that you are an Outlook genius? Would you
enjoy the respect and additional income that could come from being able to
help everyone in your office on Microsoft Outlook? Get your Outlook
Specialist certification and realize the benefits it can have.
"Are You Certifiable (In Outlook, At Least)" is available at
http://www.linkemup.us/areyoucertifiable.htm for only $18. It will go
through each subject on the test and help you to prepare for this
certification. If you do not plan to get certified but need a little extra
help on using Outlook it is an excell...32 bit and 64 bit question
Will the 2007 Office for Homes run on both 32 bit and 64 bit processors?
"bernie" <firstname.lastname@example.org> wrote in message
> Will the 2007 Office for Homes run on both 32 bit and 64 bit processors?