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
|