subtotals #3

I would like to create a macro (or vba function) that subtotals by user
then by type.  I have two fields that I would like to total, amount and 
reimbursement amount.
I would like the macro to sort and subtotal on type and then provide a grand 
total
by user.
I have three different types (P, C & R).
I tried using the sort and subtotal functions in excel (2003) but have not 
had any
success.  Can someone please point me in the right direction?
kind regards,
0
DumbCluck (2)
12/10/2007 8:06:00 PM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
364 Views

Similar Articles

[PageSpeed] 26

Since you provide little info, If I understand you don't need to subtotal. 
Try this idea

=sumproduct((a2:a22="P")*(b2:b22="username")*c2:c22)

-- 
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"DumbCluck" <DumbCluck@discussions.microsoft.com> wrote in message 
news:7AD9A553-B336-431D-9D55-8DD8BBDB29E1@microsoft.com...
>I would like to create a macro (or vba function) that subtotals by user
> then by type.  I have two fields that I would like to total, amount and
> reimbursement amount.
> I would like the macro to sort and subtotal on type and then provide a 
> grand
> total
> by user.
> I have three different types (P, C & R).
> I tried using the sort and subtotal functions in excel (2003) but have not
> had any
> success.  Can someone please point me in the right direction?
> kind regards, 

0
dguillett1 (2487)
12/11/2007 1:15:55 PM
Reply:

Similar Artilces:

Error message #3
Hi, everyone, I open to MS Excel 97, the following error messages was shown on screen. 26146100: file format is not valid. Please help Thanks Jimmy Something that is being opened is causing trouble. It could be an addin checked in Tools|Addins or a file in your XLStart folder (or if you are using tools|options|General|"Alternate Startup File location", it could be in there.) (Not many use the alternate startup file location, so try erasing that value from that box in excel--don't delete the real folder. If that fixed it, you're done.) If not, your task will be to...

Error when adding an Attribute i CRM 3.0
Hi. I know this is a long shot, and it can be a million things. But suddenly I can't add Custom Attributes to the database. The dialog after "save" is: "An error has occurred. For more information, contact your system administrator". I have set the "<add key="DevErrors" value="On"/>" and hoped that the dialog box would tell me more. But I got the same message. There is no problem in adding existing fields to existing forms, and I can publish then without any problems. Any ideas? Best regards and thanks for your h...

excel files #3
When I click on excel file on desktop or through my documents, excel opens with a blank grey page and dialogue box saying file couldn't be found. I then close the box and can access the file through file and open, I used to just click and it opened instantly, what has gone wrong? ...

Transfers #3
I would like to suggest a modification to the Inventory Transfer Out/In function. We use both HQ and SO and we are getting used to running a report, exporting the data, adjusting the data, running the required worksheet and then importing the data to the worksheet. This is particularly helpful with changing sale prices. It would also be useful with the SO transfers. I am surprised to find that the export/import function does not exist in the Inventory Transfer. This should be modified for future releases of the software. (Unless, of course, there were significant down sides to it) Than...

Zip Codes #3
I have a list of names and addresses in Excel. Some of the zip codes are in just the regular 5 digit zip code format and some are in the zip + 4 format. I would like to eliminate the additional 4 digits off the zip codes that have them without having to manually delete those numbers from each cell. Is this possible? There are easier ways if the zip codes are in a separate column (take a look at Data, Text to Columns, using "-" as a delimiter), but in case your zip code is included with the rest of the address this formula will work provided the zip code is the last item i...

Timestamp a sheet #3
That works good. Thanks alot -- eluehman ----------------------------------------------------------------------- eluehmann's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1309 View this thread: http://www.excelforum.com/showthread.php?threadid=26418 Your welcome, thanks for the feedback -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 2003 ** remove news from my email address to reply by email ** "elueh...

emails appearing after 4 years, again! #3
I've recieved an email that was sent to me 4 years ago, in my Inbox. What causes this? The Sender is still working with me and he definitely does not have a copy of the letter. ...

MSExchangeTransport EventID 929 #3
Every hour I get the same messages in the Application Event Log on our Exchange server. The messages are as follows: " Failed in reading Connector's DS Info Process Id: 1280 Process location: C:\WINDOWS\system32\inetsrv\inetinfo.exe ConnectorDN: CN=Connector for Lotus cc:Mail (TLBEXCHANGE),CN=Connections,CN=First Routing Group,CN=Routing Groups,CN=First Administrative Group,CN=Administrative Groups,CN=TLB,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=TLB,DC=Local Hr:c004038a Attribute:[homeMTA] For more information, see Help and Support Center at http://go.microsoft.com/fwli...

How do I set up more than 3 conditional formatting?
Hi, I have 6 different investigation area, one single name each, and I would like to set 6 different conditional formatting. But I'm not able to set more than 3. Any idea how can I manage it? Many thanks You can use a macro. What are your conditions / desired formats ?? -- Gary''s Student - gsnu201003 "Pomodoro" wrote: > Hi, > I have 6 different investigation area, one single name each, and I would > like to set 6 different conditional formatting. But I'm not able to set more > than 3. > > Any idea how can I manage ...

CRM 3.0
Just working with the beta of 3.0. Is there a quick way to send an e-mail template or even just an e-mail to a selected list of contact. What I mean is, in a list of contacts, if I choose say 3 or 4 contacts, is there some way to quickly choose somehow to send them an e-mail. If I choose them and create a new e-mail task their names do not appear in the to list. Also if I want to send a template e-mail to them, can it be done this way or does it have to be done another way? I know you can create an e-mail activity, then add all the names into the to list but this would be the revers...

In CRM 3.0 is there a way to Hide the Sales or Maketing or Service
I want to be able to control users access to different sections of CRM. So I want Jane Smith to see Sales and Marketing, and Scott Riley to only see Sales and Service. Doing by team would also work. I was able to create custom Roles and control entiy access but I don't see a way of controlling section access. Mike Sections only appear if the user has access to one of the items within that section. Unfortunately, there are some shared objects across the sections (like Account/Contact) that prevent them from disappearing totally. -- Matt Parks MVP - Microsoft CRM "Hotwheels...

Office 2003 #3
I installed Microsoft Office 2003 and cannot create, reply or forward email. I am receiveing the error message "The messaging interface has returned an unknown error. If the problem persists, restart Outlook. I have applied all of the updates for Office 2003. I'm having the exact same problem...same message. I tried uninstalling and reinstalling, as well. No help! >-----Original Message----- >I installed Microsoft Office 2003 and cannot create, reply >or forward email. I am receiveing the error message "The >messaging interface has returned an unknown e...

Slow Performance #3
Outlook is performing very so. It takes approx. 5 seconds to open an email. All other apps. open 1 second. I know I have enough memory and a fast processor. Problem began last week. Help! ...

3 Installs on 3 Different Computers?
I installed Microsoft Office 2004 (Student Edition) on my iBook when I purchased it, then reinstalled it after some slowdown. I used two different access keys...does this mean that I have installed it on two different computers? Can I use the access key that I used during the first install again, or will I have to use the third key? The reason I ask is that my family's going to get an iMac and I will install it on that, but then when I get a new laptop will I be able to install using one of the first two access keys? Thanks. You could have reinstalled with the same key, that you used ...

Full-Text Indexing #3
Is there a way to enable full-text indexing in an outlook client for Public Folders when the client is working offline? ...

bad mail #3
We regularly have email sent to us where the recipients name is incorrectly spelt causing the mail to get bounced. Is their a way within exchange 2003 that these email or others that contain our @domain.com be delivered to a bad mail account so we can manually filter what’s needed or not. Thanks David On Fri, 16 Dec 2005 02:05:02 -0800, Daveed <Daveed@discussions.microsoft.com> wrote: >We regularly have email sent to us where the recipients name is incorrectly >spelt causing the mail to get bounced. >Is their a way within exchange 2003 that these email or others that contain &...

Help needed #3
Many thanks to JE McGimpsey Solved my problem -- okane ----------------------------------------------------------------------- okanem's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=930 View this thread: http://www.excelforum.com/showthread.php?threadid=27656 ...

CRM 3.0 #2
Many times i try built new campaign and i have a problem with template, i want use some "template" to mailing action, because i don't want do 100 e-mails by foot. please help me sroobka@o2.pl ...

End of Year #3
How do you close the end of year in Money 2004. I went throught the book and KB and nothing. Please Help It don't think it needs to "close". The only thing I can think of that it effects in the tax estimate on my home page that rolls to 2005 information. All reports can by selected for prior year data. "CJR" <CJR@discussions.microsoft.com> wrote in message news:8D8AF1EE-481D-423D-9FD8-BF076405E4BC@microsoft.com... > How do you close the end of year in Money 2004. I went throught the book > and > KB and nothing. > Please Help > There i...

Sorting a column by using formula #3
I am trying to use sort function just to delete blank cells in between Sort order doesn't matter actually. Data is coming by the use of simple cell reference of "another sheet -- Prais ----------------------------------------------------------------------- Praise's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1558 View this thread: http://www.excelforum.com/showthread.php?threadid=27144 Hi you may use the following addin to filter out blank cells: http://www.rondebruin.nl/easyfilter.htm -- Regards Frank Kabel Frankfurt, Germany Praise wrote: &g...

CRM 3.0 - Web UI
Just wondering if anyone else has had this problem occur with their install of CRM 3.0. When you try to access the WorkPlace >> Calender page within the web application, i always get an error message when it tries to open the aspx page (home_calender.aspx). The error states "Unexpected error - an error has occured contact your system administrator" Any ideas as to why i would not be able to open this page ?? The user trying to open it has all roles assigned to it within CRM, and is a domain admins (Windows 2003 server, running Sql 2005, Exchange 2003) I am experienci...

Looping error 5.3.5 we trying to send to domains we host.
I work for a IT consulting company. We also host domains. We are running Exchange 2003 on the same server that we host the domains. We are using SmarterMail for out domain/web hosting. We we attempt to send emails to any of the domains that we host we receive the error message below. We ARE able to send to all other domains except for these (ie yahoo, msn, etc). We do not have multiple virtual servers nor do we have any smtp connectors. IP address for the one virtual server is set to all unassigned. blank@adomain.com on 3/14/2005 4:00 PM A configuration error in the e...

Last Saved Date #3
Excel 2003 In Word 2003 it is possible to insert a field that will show the date and time that the document was last saved. I have been trying to find something similar for Excel that I can insert as part of a custom footer, or at least in a cell somewhere on the page. How can I get the date and time of the last save to show in an Excel file? --Tom To place in a footer.................. Sub foot_date() ActiveSheet.PageSetup.RightFooter = "Last Saved : " & _ Format(ThisWorkbook.BuiltinDocumentProperties("Last Save Time"), _ "yyyy-...

Integration between MS CRM 3.0 and OA2007
Hi guys, Have you heard of any tool that provides integration between MS CRM 3.0 and OA2007? Recently, it seems that a number of people are looking forward to have this tool. In line with this, we are currently developing a connector between Microsoft Dynamics CRM 3.0 and Microsoft Office Accounting 2007, and we are looking for CRM users, small business specialists and interested professionals who are willing to be advisors for this endeavor. Advisors will have the chance to influence the features of the software we are building and will get to evaluate pre-release versions of our applicatio...

File Locked Error
I'm still trying to talk our IS group into rebooting the server... I'm a little curious how the lock actually follows the file. Even i we copy it to another computer, the XL file still complains the file i locked. Is there a lock flag that is embedded in the file properties? Steve Lady Layla Wrote: > If the file is stored on the server and the file is saying it is locke > by a > user -- if the user's system has been rebooted, most likely the onl > thing that > will release the lock is rebooting the server. It is unfortunate bu > it does > have to be do...