Total a column from sheet 2 based on value in sheet 1
Col B Col C Col F
Mary Team 1 $331.00
George Team 1 $222.00
Sam Team 2 $186.00
Tom Team 2 $100.00
Above is an example of my data on Sheet 2. On Sheet 1, I want to total all
the total funds raised per Team shown on Sheet 2. I am trying to create a
summary of what each team raised.
I tried using the formula: =SUM(('sheet 2'!F2:F482=Sheet1!B2)) and I get
just a dash in my total col.
Can anyone provide some help?
Look in HELP for the SUMIF() function
Microsoft MVP - Excel
"Nee...Also Can't Install Latest Update
Operating System: Mac OS X 10.5 (Leopard)
I'm using a registered version of Office 2008, version shows 12.0.0. Have been trying to install the latest patch 12.1.0 with no success. It sits for ages on the 'examining additional volumes' stage (there are no additional volumes) and then eventually puts the red exclamation mark on my disk with the note, "..a version of the software required is not on this computer.."
I have tried the Autoupdater and the standalone download. Have tried with nothing else running (shift key held whilst logging-in)...Business Portal Web Services
I am trying to setup the Microsoft Dynamics Security Synchronization Utility.
I am adding a new application for the Web Services - Dynamics GP.
How do I determine my Application Key ID?
gptech, thanks for using the newsgroups.
In this case, the "Application Key" can be found in the web.config file in
the installation directory for the GPWebServices. (Typically Program
Files\Microsoft Dynamics GP\GPWebServices\WebServices.) Look for the
"SecurityApplicationKey" setting. Unless something has been customized, the
ID is likely this GUID:
I have a question..I have a client and they want us to test things on a
machine beofre he moves it out into the lanes...
is there a way that I can install on a machine thats not going to be a lane
for testing purposes then be able to transfer it to a lane with no problems?
I think you just need to get the demo version first for testing
"Angelique" <Angelique@discussions.microsoft.com> wrote in message
>I have a question..I have a client and they want us to test things on a
> machine beofre he moves it out ...Failed to install: Business Data Lookup Snap-in for CRM 3.0
I went through the Installation wizard without errors or warnings.
The Business Data Lookup Snap-in for Microsoft CRM toolbar does not appear
in Word or Excel. I have tried to do as was instructed in readme-file, but it
I should click View -> Toolbars -> Business Data Lookup Snap-in for
Microsoft CRM, but the toolbar is the same than before (no Business Data
...How to tell what Updates have been Installed?
I just tried the Microsoft AutoUpdate and it says there are no updates
for your software at this time. I then clicked on the "View Installed
Update" button and shows no history. Just blank page.
My Entourage version is 12.0.1 and I think this is the current version.
Should the 12.0.0 to 12.0.1 update be displayed on the installed updates
How can this update be added to the blank installed updates page?
There were some issues with 12.0.1, obviously--it doesn't show on my
I don't know for sure, but I would expect that 12.1 will be a combo
updater...CreateSalesOrder Web Service returning exception
When attempting to create a new Sales Order via the CreateSalesOrder web
service in GP 9, I receive the following error:
-------------- Begin Error ------------------------
A validation exception has occurred.
- The U of M for the item is not specified in the item price list as the
default selling U of M.
- U of M does not exist for the Unit of Measure Schedule being used.
- PriceListKey is blank. It must be passed in or a default must exist for
-------------- End Error ------------------------
If I specify a Unit of Measure for each SalesOrderLine,...Page Numbering (Starting Number Other Than 1)
I am at a loss as to how to start page numbering with
number other than 1. I am using Office Pro 2003 with
When I go to Tools/Options, I do not find the familiar
menu "Start Numbering With . . " menu.
What to do??
Go to Page 1, Insert|Section
JoAnn Paules - MVP Microsoft Publisher
"Bill" <firstname.lastname@example.org> wrote in message
> I am at a loss as to how to start page numbering with
> number other than 1. I am using Office Pro 2003 with
> Publisher 2002.
> When I ...Value Pak Installer
Does anyone know how I would access Value Pak installer for Mac Office X?
Can it be downloaded from the Microsoft web site, and if so, where?
On 3/6/04 6:59 am, in article email@example.com,
"Brian" <firstname.lastname@example.org> wrote:
> Does anyone know how I would access Value Pak installer for Mac Office X?
> Can it be downloaded from the Microsoft web site, and if so, where?
For Office vX, the value pack is on the installation CD.
For Office 2004, there is no separate value pack.
Barry Wainwrigh...1 email fill my queue!!!!
I'm testing a deployment of the CRM 1.2.
I test the exchange filter to get email sent to email@example.com.
This works fine... but...
every 30minutes the same email is added to the queue again!!!!
I have done 2 tests, and these 2 emails are copied every 30minutes...
I have omit to check the "associated external account" option in the
Exchange advanced options.
"J�j�" <willgart_A_@hotmail_A_.com> wrote in message
> I'm testing a...Vista Ultimate, Invalid Disk Pack
A weird problem. I used to have 3 USB disks (dynamic GPT) running fine under
Vista Ultimate. Then I made a fresh Windows 7 Home Premium install. Noticing
that it didn't recognise my disks (and other problems as well), I decided to
go back to Vista Ultimate (using Windows.old).
But now the original Vista Ultimate installation didn't recognise them
either! They have status Invalid in Disk Management Console. DISKPART sees
the disks, and also the partitions, but it doesn't appear to find any
volumes. Any command I try to do returns the error message that it is no...Do I need to install Office 2003 updates for Window 7?
I have a new computer with Window 7 operating system. I used my original disk
and product code to install Office 2003 and it seemed to go well. Now I am
wonering if I need to go back and install Office 2003 updates. I am
primarily worried about Office 2003 security but thinking maybe Windows 7
takes care of that. If Windows 7 does not, which ones need to be used to
update and how do I get access to them?
"Gracious" <Gracious@discussions.microsoft.com> wrote in message
> I have a new computer with ...Installation #4
I am not sure that I am in the right place but I am
trying to install Disc2 of Office 2000 Pro on Windows Xp.
I keep getting a Not Responding prompt after I key in the
Product Key Code. It identifies a file or something that
is ---- SzAppName: msiexec.exe
I really could use some help getting this resolved. I was
able to install Disc1 with Word and such on it. I would
like to install Disc2 that has Publisher and Small
Please advise ASAP.
Hi Paul (firstname.lastname@example.org),
in the Microsoft� newsgroups
|| I am not sure that I am in the right place bu...Help
Hi all, When I am working from home Outlook will make a local copy of the
emails from the exchange server to my home computer.
How do configure Outlook to leave the emails on the Exchange server so that
they are only in one location?
Must be a simple mistake in the set-up of either Exchange or Outlook.
Any help appreciated.
Your Outlook client should be configured to deliever messages to your
Exchange mailbox, not to a PST.
"Pratish" <email@example.com> wrote in message
> Hi all, When I am working from home Outlook will ...Installer for my access application
I searching for installer for my program.
It must support creating link like "path to msaccess.exe" "path to
myprog.mde" /wrkgrp "path to users.mde"
Is anybody know best solution for this???
Thank you in advance.
With best regards, Alek Luchnikov. E-mail:
Look at Inno setup. It's free.
"Alek Luchnikov" <alekluch---FORSPAMERSfirstname.lastname@example.org> wrote in message
> Hello, All!
> I searching f...Rescue Vista
In the event of Vista becomming infected such that it wont boot, it
might be a good idea to download a rescue disk in advance.
Any free recommendations. I connect via wifi.
> In the event of Vista becomming infected such that it wont boot, it
> might be a good idea to download a rescue disk in advance.
> Any free recommendations. I connect via wifi.
Google is your friend. UBCD4Win, Knoppix.
TRYING THE SA...Fresh install, crystal issue.
During an install on an Enterprise server 03 SP1, I have run into DEP or Data
Encription Protection. This stops each of the crystal services upon install
and therefor after the install we recieved the infamous crystal license
error. We checked and the APS service is not started and will not start no
matter what we try. Also there is three tables missing from the Crystal
database: APS_IdNumbers2, APS_InfoObjects2 and APS_VersionInfo.
I am guessing that the missing tables is the reason the APS wont start, If I
copied these three tables from another database would this work for getting
...Customizable metrics on home page for GP 9.0
I like the concept of having Metrics available on the home page. However, I
would like to have the ability to create metrics that are meaningful to my
company instead of only selecting from a short list of canned reports.
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...Installing XP over Linux
I am trying to install Windows XP on a Dell laptop that currently has Linux
Ubuntu installed. After booting up with the Windows CD in the drive, it
loads various Windows files, but eventually stops on a blue screen message
advising me to run CHKDSK, but won't respond after that. I suspect that
Windows is seeing the Linux partitions as disk corruption, but how can I get
"Kev" <email@example.com> wrote in message
>I am trying to install Windows XP on a Dell laptop that currently has Linux
>Ubunt...CRM SBS install error
I installed CRM on SBS 2003 and had 1 problem with the Reporting Server being
incorrect. But the CRM Setup Wizard tool would not run (kept getting an
So, I tried a repair of the CRM setup - no good. Then did an uninstall, and
re-install. The install will not work - I keep getting the following error:
Action Microsoft.CRM.Setup.Server.RegisterFaxService failed. The
configuration registry key is invalid.
I have not seen any posts that mention an error like this. Any idea what to
Were you installing on SBS 2003 premium?
...Cannot see installed fonts in programs after installing with Font
OS 10.4 with current updates. Installed a TTF using the Font Book and it
shows there correctly. But when going into Word for example, type in text,
highlight it, click on the font format and the new font that was installed
will not show in the list. I have already tried deleting the font cache,
then rebooting and reinstalling the font thru the Font Book and just manually
copying to the /Library/Fonts folder.
Althought it sounds like you may already be aware of what it refers to,
below is an excerpt from;
http://www.macreviewzone.com/archive/hardcider/guestreviews/swope/osx_fonts.sht...Internet Printing: Printer Installation Failed. The driver files are not available for the current CPU platform
I have a SBS 2003 machine, I have 2 shared printers set up on it for
remote users to print via IPP. Both printers are connected to Windows
When I browse to https://servername/printers, I see all the printers.
I can use the Connect link to install one of the printers on my
workstation however if I select the second printer and click on
Connect I eventually get the error:
Printer Installation Failed
The driver files are not available for the current CPU platform.
contact your administrator to install proper driver files on the
I've v...Issue installing KB916803
I currently have a problem trying to install the above hotfix. I am trying
to test this hotfix with Exchange 2003 server running SP2. I have downloaded
the SP2 version of the hotfix from MS, but when I try to run it on my
Exchange BE server, I get an error back telling me that the version of
Exchange I have is too old, and that I need to install SP2 (even though that
is what is installed)!
I have tried reinstalling SP2, which didnt fix the problem. I then tried
installing on a FE server, which had the same issue. I have now tried this in
four different E2k3 SP2 servers, and all ...client installation
i have installed crm 3 server and it working fine.
when i try to install the client i get this message :Action
microsoft.crm.setup.client.installabpaction failed exception from
can you help please
What version of windows/outlook is installed?
Which version of the outlook client are you installing (laptop or desktop)?
Are you installing from the CD, or across a network share?
At what point does it fail?
"Gil Gilon" <Gil Gilon@discussions.microsoft.com> wrote in message
&g...DOES ANYONE KNOW HOW TO INSTALL SPELL CHECK?
Go to www.c360.com. You can download a small spellcheck "add-on" that works
with iespell. It's free and it works well.