Sum in a column if there are 3 conditions in another columnI need to find the total from Col B if Col A is one of the 3 possibilities
A B
DONE 0
DONE 60
OBS 40
POST 55
DONE 40
DONE 0
DONE 47
POST 55
DONE RESULT
OBS RESULT
POST RESULT
Try the below for total for "Post"
=SUMIF(A:A,"Post",B:B)
'Try the below for total of all three
=SUM(SUMIF(A:A,{"Post","OBS","Done"},B:B))
--
Jacob (MVP - Excel)
"DogmaDot" wrote:
> I need to find the total from Co...
How do I subtotal pages in Excel?I want to subtotal a column per page in Excel 2000, however the page may vary
as I add and delete records. Can anyone help me?
Shouldn't be a problem as XL will automatically adjust it's total
formula as you add and delete.
I'm assuming you are putting in a sum formula ("=sum( cell1:cell2)").
--
Regards;
Rob
------------------------------------------------------------------------
"lshivvers" <lshivvers@discussions.microsoft.com> wrote in message
news:B81870EF-D160-4628-96A2-3CDC5FB07BBD@microsoft.com...
> I want to subtotal a column per page in Ex...
Opening a unicode CSV file from ExcelHi,
I'm currently working on an application that can export data in "CSV"
format, and then launches Excel to view the CSV data. This works
perfectly ok for ascii data.
However now I have upgraded our application to use Unicode I'm running
into problems. When I export data into a unicode CSV file and launch
excel with it's path on the command line I get a "This is not a
recognized format" message. If the same file is opened manually from
Excel the same error is shown but afterwards the text import wizard is
displayed (which works ok).
Currenly the file is 16 ...
Excel #81I need to know the importance of excel and what are the
uses of excel.
Your responce in this matter will be highly appreciated.
Regards
Qinisile
There's lots of information on Excel on the Microsoft site:
http://office.microsoft.com/en-ca/FX010858001033.aspx
Qinisile Bukhali wrote:
> I need to know the importance of excel and what are the
> uses of excel.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
...
Must buy new computer...Ideas?Hello to all! Finally my over 10-1/2 year old Dell desktop's extreme
slowness has seriously gotten on my nerves and I'm now looking for a new
one. (Surprisingly, it's working pretty well otherwise...)
Maybe this isn't the right forum? But beside the usual things like RAM and
HD GBs, are there things I should be sure to have...or be careful NOT to
have on a desktop? After n ot looking into computers for over a decade I
feel like a Martian in the Earth. lol!
Also, is it possible to transfer to the new one ALL my stuff, including
programs, etc.? Do you thin...
Default properties for new foldersHow does one set the default properties applied when
creating new email folders? Currently, when I create a
new folder, it is created with the AutoPreview turned on
by default. I'd like to change that do that it is left
off by default. It's something of a pain to create a new
folder and then go in to customize it's properties.
You can do this by editing the Messages view; View-> Arrange By-> Current
View-> Define Views...
You might want to define a new view yourself and apply that view on first
use of that folder.
--
Robert Sparnaaij [MVP-Outlook]
www.howto-o...
Excel charts #12I am trying to format the individual labels on the category axis on an Excel
chart. I want every other label in a different color and bold. But the
entire category axis is formatted. Does anyone have a suggestion? The
category axis is years - 1990 through 2005. I want the odd years to be bold
and a different color than the even years.
When Excel doesn't let me do what I want with a chart axis, I draw my own:
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html
Use this technique to make two different axes, one for even and one for
odd, and hide the default axis Excel draw...
Excel memory issuesWe have several excel spreadsheets on a network drive that when opened by
any client they receive several errors relating to memory, such as:
Not enough memory
Not enough system resources to display completely
Any ideas? We have increased RAM on server and workstation and page file,
but the users are still receiving the errors.
Did you increase the memory on the client's machine? You never mentioned if
they have enough harddrive space.
"Neil Shirley" wrote:
> We have several excel spreadsheets on a network drive that when opened by
> any client they receive s...
New Email MessagesI just installed Outlook 2007 on my new PC and for some reason the new
messages I received can only be received when I press the SEND/RECEIVE
BUTTON. My Outlook at work receives these new mail messages as they are
received. So how can I configure the system to make that happen?
--
The Trail Hiker!!
There are two settings within the accounts
1) Send on starting
2) Auto send/receive every xx minutes - set this for 10 minutes
"hiker0531" <hiker0531@aol.com> wrote in message
news:87259C7A-5C07-4846-BF61-DE3F98345D21@microsoft.com...
>I just installed Outlook 2007 on my n...
Unable to open "New" window to write email.I am using Microsoft Outlook in Office 2003. It has been working great until
today.
When I click "New" to write a new email I get an error window :
The messaging interface has returned an unknown error. If the problem
persist, Restart Outlook.
I have tried this several times, even restarted the computer to no avail.
Anyone have a solution????
...
Prevent new comments on old posts in sharepoint blogsHow do I stop comments on certain posts in a SharePoint blog?
I have removed permissions to the specific post to the lowest possible
access and people can STILL post a comment. If I uncheck one more item in the
list of permissions, the users can no longer see the post.
Any suggestions?
...
excel spreadsheet #8I have a 2 sheet excel spread sheet that I put together
with varing column widths.
On the top 1/4 of the first sheet (of the 2 part spread
sheet) I need to have different column widths to insert
specific data with different column widths that conflict
with the column widths in the balance of spread sheet.
How do I seperate the sheet to have the column with at
the top 1/4 differ from those on the rest of the sheet?
I treied cut & paste within excel, I tried building the
top part in word and paste to excel. nothing works.
Can this be done?
Frank
...
A Short Video on Adding/Editing New CustomersIf capturing customers at the POS is important to you, take a couple of
minutes and watch this video. This application also allows for edit of
Global customer information in HQ installations.
http://www.retail-pos.com/ReverseLookup.wmv
Contact us for detailed info and demo.
sales(at)retail-pos.com
www.retail-pos.com
It would be nice if you could encode the videos with a more common codec,
and not in wmv format. This requires the GTM3 codec (GoToMeeting). Windows
Media Player 11 doesn't automatically download the codec, and I'm not going
through the trouble to download and in...
distributing columns evenlyHi again
I've a list of 200 nos. in a single column (say A1:A200)
I want to distrubute it like this:
A1:A50 contains 50 nos.; B1:B50 contains 50 nos. and so on
Please help
--
Reg
Deepak
AGM Communications
Hi
do you need this for printing. If yes, see:
http://www.mvps.org/dmcritchie/excel/snakecol.htm
--
Regards
Frank Kabel
Frankfurt, Germany
Deepak wrote:
> Hi again
>
> I've a list of 200 nos. in a single column (say A1:A200)
>
> I want to distrubute it like this:
>
> A1:A50 contains 50 nos.; B1:B50 contains 50 nos. and so on
>
> Please help
...
Make excel run large spreadsheets fasterFor those of you who run large spreadsheets with or without VBA, I think
everyone will agree they are much too slow
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=e1105194-24af-4697-ab5f-b9d62e5140ea&...
New Location/New setupCurrently I'm downsizing our office, and moving to a new location. I'm
running MS Server2003 as well as Exchange 2003. Once moved, I will no longer
require the server (since I am setting up a home office).
Are there currently any steps or procedures available to correctly shutdown
one office...and basically setup a home office with no exchange server.
Also I will be removing the current pc's from the Domain, and setting up a
few in a workgroup.
I would like to receive emails from the other employees for time being until
I completely cancel this email account. I already have a...
ExcelI need to insert a space three characters from the right of a piece of text I
have in a cell. How do I do it? I was thinking along the lines of customer
formatting but this is proving troublesome as I'm an Excel novice.
Thanks,
Darren
If your piece of text is in cell A1, you could put the following formula into
a helper cell (such as B1): =LEFT(A1,3)&" "&RIGHT(A1,LEN(A1)-3). If you
want to convert the formula back into text, click on B1, press Ctrl+C to copy
it, then click on Edit | Paste Special | Paste: Values | OK.
"Dazza" wrote:
> I need to in...
How do I activate the new mail buttonWhen I start Outlook, the "New", "forward", "reply" and "reply to all"
buttons are not active which means I can not send mail. I have no problems
receiving mail. Also, on web pages with email links, when I click on them,
the Outlook application is not launched which is almost certainly related to
this. I think I'm missing something very simple here!
Are you in a mail enabled folder? Do you have an active email account
installed?
--�
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert...
Huge spreadsheet spanning 600 rows...User wanted this to print on 11x14..it spanned the entire
page and then some..where would I first look to edit to make this easy to
read.
Hi
you might want to investigate data / format / autoformat to limit the number
of row printed at a time
or you might like to have a look under file / page setup - sheet tab for
rows to repeat on each page (ie headings) & the printing of gridlines
other than that you'll need to give us a more specific idea of what you're
trying to achieve.
Cheers
JulieD
"~D~" <someone@microsoft.com> wrote in message
news:uQU4Z$mqEHA.3...
excel #136I have files in quantrum pro and would like to open them in excel. But they
won't popen
I'm not familiar with Quantrum Pro. What does it do?
"Liz R" wrote:
> I have files in quantrum pro and would like to open them in excel. But they
> won't popen
...
Excel 2007 werkbalk snelle toegang, "hoe te saven voor nieuwe excel install "Wie kan mij vertellen hoe de werkbalk "snelle toegang"met al zijn icons is
te saven.
Dit ivm een nieuwe installatie van excel. Het voorkomt dat ik al die icons
wederom moet opzoeken.
Al vast bedank voor de hulp.
gr
Peter
See
http://www.rondebruin.nl/imageqat.htm
You can find the file here
Excel saves your QAT setup in a file named "Excel.qat" in:
C:\Documents and Settings\<username>\Local Settings\Application Data\Microsoft\OFFICE\Excel.qat
In Vista you can find it here
C:\Users\<username>\AppData\Local\Microsoft\Office\Excel.qat
Note: This file will no...
Style available all sheets new or oldI need a custom style that is available in all
spreadsheets, new or old. I can set style and save it in
book.xlt in xlstart, but that only works for new
workbooks, and doesn't work with old spreadsheets when I
call them up. I want to be able to select a group of
cells, or column or row and apply a setting for negative
numbers to have brackets. I am using Excel 2000.
I even tried saving the style in personal.xls, but that
doesn't work as it is hidden.
Do I have to use a macro? And if so what would it be?
Thanks
One way:
Public Sub MergeStyles()
ActiveWorkbook....
Sub Form Assigning New Values to Old RecordsI am using a subform within a form to have users update certain fields in the
record where the rest remiain locked. On the Main form when the list box
(which is bound to a query) is used to select the record set to display in
the subform it sometimes takes an old record and assigns a new value to the
record. For example it changes the Period field from 9 to 10. Taking a
record created in period 9 and assigning a period ten to it which is the
selection I make in the list box. Addtionally, it looks like it is taking
the first record in the related table to assign this new value to. ...
Excel drawings with HyperlinkHello:
I would like to create a hyperlink when a particular serial number is
selected in a cell. Is there a way to create small drawings in excel and
have those drawings pop up (or via hyperlink) when a given serial number is
selected from a cell? I have created drawings in Paint and saved them as
JPEG images, but when I select a serial number the Paint editor pops up at
full screen with a tiny image.
Regards,
D.Parker
What I have done in the past was insert drawings on the worksheet, hide
them, then associate VBA code to unhide the desired drawing (picture) and
hide all others.
...
Which table will refresh by adding new Account / ContactHi,
I am new to CRM and trying to update CRM Accounts and Contacts from our
Sales Management system. I am using Micorosft Bulk Import utility. I am in
preparation of CVS files but not sure what columns do I need in CVS file to
complete one Account/Contact record. Could anybody please help. I am .NET
expert developer, please let me guide If I could develop CRM by using .NET
not CVS
Regards
Hi Adnan,
Microsoft do provide CRM SDK for CRM enhancment using .net. You can download
from following url
http://www.microsoft.com/downloads/details.aspx?familyid=9C178B68-3A06-4898-BC83-BD14B74308C5...