Search EggHeadCafe's Job Board
EggHeadCafe Silverlight WPF ASP.NET VB.NET C# Excel SQL Server SharePoint
search
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

WebArticlesForumsFAQs
JavaScript
ASP
ASP.NET
WCF

DatabasesArticlesForumsFAQs
SQL Server
Access
Oracle
MySQL
Other Databases

OfficeArticlesForumsFAQs
Excel
Word
Powerpoint
Outlook
Publisher
Money

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

Operating SysArticlesForumsFAQs
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
Lounge
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  Ask New Question With Power Editor

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

 

 

 

Reply    Reply Using Power Editor
  Rank Winnings Points
November 0 $0.00 0
October 0 $0.00 0