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