search
Japanese Chinese Nederlands Espanol Italiano Deutsch Francais Twitter Rss Feeds
MicrosoftArticlesForumsFAQs
C# .NET
VB.NET
Visual Studio .NET
ADO.NET
Xml / Xslt
VB 6.0
.NET CF
GDI+
LINQ
Deployment
Security
FoxPro
Silverlight / WPF
Entity Framework
RIA Services

Web ProgrammingArticlesForumsFAQs
JavaScript
ASP
ASP.NET
Web Services

Non-MicrosoftArticlesForumsFAQs
NHibernate
Perl
PHP
Ruby
Java
Linux / Unix
Apple
Open Source

DatabasesArticlesForumsFAQs
SQL Server
Access
Oracle
MySQL
Other Databases

OfficeArticlesForumsFAQs
Excel
Word
Powerpoint
Outlook
Publisher
Money

Operating SystemsArticlesForumsFAQs
Windows 7
Windows Server
Windows Vista
Windows XP
Windows Update
MAC
Linux / UNIX

Server PlatformsArticlesForumsFAQs
BizTalk
Site Server
Exhange Server
IIS

Graphic DesignArticlesForumsFAQs
Macromedia Flash
Adobe PhotoShop
Expression Blend
Expression Design
Expression Web

OtherArticlesForumsFAQs
Subversion / CVS
Ask Dr. Dotnetsky
Active Directory
Networking
Uninstall Virus
Job Openings
Product Reviews
Search Engines
Resumes

 

View Other Microsoft Excel Posts   Ask New Question 
how do i add up all the invoices in a specific month for a specific vendor
Xavier Martinez posted at Tuesday, May 19, 2009 2:59 PM

I have two tabs Expenditures tab , and monthly report

I was able to figure out two formulas, I just need to know how to combine them

1.  Gives me the total of all vendors and invoices that are for the month of Feb 2004,

=SUMIF('Phase V-Expenditure-T'!$Q$9:$Q4000,"<="&DATE(2004,2,29),'Phase V-Expenditure-T'!$V$9:$V4000)-SUMIF('Phase V-Expenditure-T'!$Q$9:$Q4000,"<"&DATE(2004,2,1),'Phase V-Expenditure-T'!$V$9:$V4000)

  • In Phase V-Expenditure-T' Tab Colum Q9:Q4000 are the invoice dates
  • In Phase V-Expenditure-T' Tab Colum V9:V4000 are the amounts of the invoices

2.  Returns the total amount invoiced for a specific vendor, (not by month)

=SUMIF('Phase V-Expenditure-T'!$N$9:$N$4000,$C34,'Phase V-Expenditure-T'!$V$9:$V$4082)

  • In Phase V-Expenditure-T' Tab Colum N9:N4000 is the unique contract number, where each invoice is billed against

Contractor Contract Number Invoice Date Amount Invoiced
Contractor A CNT-ACC-021607-001 09/30/07 $124,945
Contractor B CNT-DCK-050208-001 09/30/07 $12,490
Contractor C CNT-VCC-092807-001 07/31/07 $429,622
Contractor D CNT-ACA-031506-001 07/31/07 $1,080
Contractor E CNT-VCC-040809-001 04/02/09 $159,710
Contractor A CNT-ACC-021607-002 06/19/08 $163,006
Contractor B CNT-DCK-050208-002 03/06/08 $168,818
Contractor C CNT-VCC-092807-002 12/31/07 $174,630
Contractor D CNT-ACA-031506-002 11/15/07 $180,442

Jan-04 Feb-04
         
1 Contractor A CNT-ACC-021607-001    
2 Contractor B CNT-DCK-050208-001    
3 Contractor C CNT-VCC-092807-001    
4 Contractor D CNT-ACA-031506-001    
5 Contractor E CNT-VCC-040809-001    

 

Thank you