Spreadsheet: 73310d1273946250-sumproduct-with-reference-to-sheet-not-returning-value-2010-budget-test
Sheet: Budget by Month-2010

Gianni Budget 2010
2010-01-01 00:00:00
 |  |  |  |  |  | Est. Expenses | Expenses |  | Difference |  |  | Est. Income | Income |  | Difference
Total Expenses / Income
 | Estimated | % | Actual | % |  |  | Estimated | % | Actual | % |  |  | Estimated | % | Actual | %
Revolving Bills |  |  |  |  |  | Monthly Expenses |  |  |  |  |  | Income
AES |  |  |  |  |  | Auto |  |  |  |  |  | AS pay
C.E. Rent |  |  |  |  |  | C.E. Expenses |  |  |  |  |  | C.E. Rent
Car Insurance |  |  |  |  |  | Clothing
Discover Card |  |  |  |  |  | Entertainment
Health Ins. |  |  |  |  |  | Food
[NAME]'s |  |  |  |  |  | Gas
M&I Loan |  |  |  |  |  | Household
MBNA Card |  |  |  |  |  | Medical
Skype |  |  |  |  |  | Miscellaneous
Sport & Health
Totals |  |  |  |  |  | Totals |  |  |  |  |  | Totals
2010-02-01 00:00:00
 |  |  |  |  |  | Est. Expenses | Expenses |  | Difference |  |  | Est. Income | Income |  | Difference
Total Expenses / Income
 | Estimated | % | Actual | % |  |  | Estimated | % | Actual | % |  |  | Estimated | % | Actual | %
Revolving Bills |  |  |  |  |  | Monthly Expenses |  |  |  |  |  | Income
AES |  |  |  |  |  | Auto |  |  |  |  |  | AS pay
C.E. Rent |  |  |  |  |  | C.E. Expenses |  |  |  |  |  | C.E. Rent
Car Insurance |  |  |  |  |  | Clothing
Discover Card |  |  |  |  |  | Entertainment
Health Ins. |  |  |  |  |  | Food
[NAME]'s |  |  |  |  |  | Gas
M&I Loan |  |  |  |  |  | Household
MBNA Card |  |  |  |  |  | Medical
Skype |  |  |  |  |  | Miscellaneous
Sport & Health
Totals |  |  |  |  |  | Totals |  |  |  |  |  | Totals
2010-03-01 00:00:00
 |  |  |  |  |  | Est. Expenses | Expenses |  | Difference |  |  | Est. Income | Income |  | Difference
Total Expenses / Income
 | Estimated | % | Actual | % |  |  | Estimated | % | Actual | % |  |  | Estimated | % | Actual | %
Revolving Bills |  |  |  |  |  | Monthly Expenses |  |  |  |  |  | Income
AES |  |  |  |  |  | Auto |  |  |  |  |  | AS pay
C.E. Rent |  |  |  |  |  | C.E. Expenses |  |  |  |  |  | C.E. Rent
Car Insurance |  |  |  |  |  | Clothing
Discover Card |  |  |  |  |  | Entertainment
Health Ins. |  |  |  |  |  | Food
[NAME]'s |  |  |  |  |  | Gas
M&I Loan |  |  |  |  |  | Household
MBNA Card |  |  |  |  |  | Medical
Skype |  |  |  |  |  | Miscellaneous
Sport & Health
Totals |  |  |  |  |  | Totals |  |  |  |  |  | Totals
2010-04-01 00:00:00
 |  |  |  |  |  | Est. Expenses | Expenses |  | Difference |  |  | Est. Income | Income |  | Difference
Total Expenses / Income
 | Estimated | % | Actual | % |  |  | Estimated | % | Actual | % |  |  | Estimated | % | Actual | %
Revolving Bills |  |  |  |  |  | Monthly Expenses |  |  |  |  |  | Income
AES |  |  |  |  |  | Auto |  |  |  |  |  | AS pay
C.E. Rent |  |  |  |  |  | C.E. Expenses |  |  |  |  |  | C.E. Rent
Car Insurance |  |  |  |  |  | Clothing
Discover Card |  |  |  |  |  | Entertainment
Health Ins. |  |  |  |  |  | Food
[NAME]'s |  |  |  |  |  | Gas
M&I Loan |  |  |  |  |  | Household
MBNA Card |  |  |  |  |  | Medical
Skype |  |  |  |  |  | Miscellaneous
Sport & Health
Totals |  |  |  |  |  | Totals |  |  |  |  |  | Totals
2010-05-01 00:00:00
 |  |  |  |  |  | Est. Expenses | Expenses |  | Difference |  |  | Est. Income | Income |  | Difference
Total Expenses / Income
 | Estimated | % | Actual | % |  |  | Estimated | % | Actual | % |  |  | Estimated | % | Actual | %
Revolving Bills |  |  |  |  |  | Monthly Expenses |  |  |  |  |  | Income
AES | 120.14 |  |  |  |  | Auto | 120 |  |  |  |  | AS pay | 2000
C.E. Rent | 452 |  |  |  |  | C.E. Expenses | 20 |  |  |  |  | C.E. Rent | 775
Car Insurance | 85 |  |  |  |  | Clothing | 35
Discover Card | 76 |  |  |  |  | Entertainment | 100
Health Ins. | 110 |  |  |  |  | Food | 250
[NAME]'s | 15 |  |  |  |  | Gas | 40
M&I Loan | 170 |  |  |  |  | Household | 25
MBNA Card | 100 |  |  |  |  | Medical | 100
Skype | 9.95 |  |  |  |  | Miscellaneous | 50
Sport & Health | 59.99
Totals |  |  |  |  |  | Totals |  |  |  |  |  | Totals
2010-06-01 00:00:00
 |  |  |  |  |  | Est. Expenses | Expenses |  | Difference |  |  | Est. Income | Income |  | Difference
Total Expenses / Income
 | Estimated | % | Actual | % |  |  | Estimated | % | Actual | % |  |  | Estimated | % | Actual | %
Revolving Bills |  |  |  |  |  | Monthly Expenses |  |  |  |  |  | Income
AES |  |  |  |  |  | Auto |  |  |  |  |  | AS pay | 2000
C.E. Rent |  |  |  |  |  | Clothing |  |  |  |  |  | C.E. Rent | 775
Car Insurance |  |  |  |  |  | Entertainment
Discover Card |  |  |  |  |  | Food
Health Ins. |  |  |  |  |  | Gas
[NAME]'s |  |  |  |  |  | Household
M&I Loan |  |  |  |  |  | Medical
MBNA Card |  |  |  |  |  | Miscellaneous
Skype |  |  |  |  |  | C.E. Expenses
Sport & Health
Totals |  |  |  |  |  | Totals |  |  |  |  |  | Totals
2010-07-01 00:00:00
 |  |  |  |  |  | Est. Expenses | Expenses |  | Difference |  |  | Est. Income | Income |  | Difference
Total Expenses / Income
 | Estimated | % | Actual | % |  |  | Estimated | % | Actual | % |  |  | Estimated | % | Actual | %
Revolving Bills |  |  |  |  |  | Monthly Expenses |  |  |  |  |  | Income
AES |  |  |  |  |  | Auto |  |  |  |  |  | AS pay
C.E. Rent |  |  |  |  |  | Clothing |  |  |  |  |  | C.E. Rent
Car Insurance |  |  |  |  |  | Entertainment
Discover Card |  |  |  |  |  | Food
Health Ins. |  |  |  |  |  | Gas
[NAME]'s |  |  |  |  |  | Household
M&I Loan |  |  |  |  |  | Medical
MBNA Card |  |  |  |  |  | Miscellaneous
Skype |  |  |  |  |  | C.E. Expenses
Sport & Health
Totals |  |  |  |  |  | Totals |  |  |  |  |  | Totals
2010-08-01 00:00:00
 |  |  |  |  |  | Est. Expenses | Expenses |  | Difference |  |  | Est. Income | Income |  | Difference
Total Expenses / Income
 | Estimated | % | Actual | % |  |  | Estimated | % | Actual | % |  |  | Estimated | % | Actual | %
Revolving Bills |  |  |  |  |  | Monthly Expenses |  |  |  |  |  | Income
AES |  |  |  |  |  | Auto |  |  |  |  |  | AS pay
C.E. Rent |  |  |  |  |  | Clothing |  |  |  |  |  | C.E. Rent
Car Insurance |  |  |  |  |  | Entertainment
Discover Card |  |  |  |  |  | Food
Health Ins. |  |  |  |  |  | Gas
[NAME]'s |  |  |  |  |  | Household
M&I Loan |  |  |  |  |  | Medical
MBNA Card |  |  |  |  |  | Miscellaneous
Skype |  |  |  |  |  | C.E. Expenses
Sport & Health
Totals |  |  |  |  |  | Totals |  |  |  |  |  | Totals
2010-09-01 00:00:00
 |  |  |  |  |  | Est. Expenses | Expenses |  | Difference |  |  | Est. Income | Income |  | Difference
Total Expenses / Income
 | Estimated | % | Actual | % |  |  | Estimated | % | Actual | % |  |  | Estimated | % | Actual | %
Revolving Bills |  |  |  |  |  | Monthly Expenses |  |  |  |  |  | Income
AES |  |  |  |  |  | Auto |  |  |  |  |  | AS pay
C.E. Rent |  |  |  |  |  | Clothing |  |  |  |  |  | C.E. Rent
Car Insurance |  |  |  |  |  | Entertainment
Discover Card |  |  |  |  |  | Food
Health Ins. |  |  |  |  |  | Gas
[NAME]'s |  |  |  |  |  | Household
M&I Loan |  |  |  |  |  | Medical
MBNA Card |  |  |  |  |  | Miscellaneous
Skype |  |  |  |  |  | C.E. Expenses
Sport & Health
Totals |  |  |  |  |  | Totals |  |  |  |  |  | Totals
2010-10-01 00:00:00
 |  |  |  |  |  | Est. Expenses | Expenses |  | Difference |  |  | Est. Income | Income |  | Difference
Total Expenses / Income
 | Estimated | % | Actual | % |  |  | Estimated | % | Actual | % |  |  | Estimated | % | Actual | %
Revolving Bills |  |  |  |  |  | Monthly Expenses |  |  |  |  |  | Income
AES |  |  |  |  |  | Auto |  |  |  |  |  | AS pay
C.E. Rent |  |  |  |  |  | Clothing |  |  |  |  |  | C.E. Rent
Car Insurance |  |  |  |  |  | Entertainment
Discover Card |  |  |  |  |  | Food
Health Ins. |  |  |  |  |  | Gas
[NAME]'s |  |  |  |  |  | Household
M&I Loan |  |  |  |  |  | Medical
MBNA Card |  |  |  |  |  | Miscellaneous
Skype |  |  |  |  |  | C.E. Expenses
Sport & Health
Totals |  |  |  |  |  | Totals |  |  |  |  |  | Totals
2010-11-01 00:00:00
 |  |  |  |  |  | Est. Expenses | Expenses |  | Difference |  |  | Est. Income | Income |  | Difference
Total Expenses / Income
 | Estimated | % | Actual | % |  |  | Estimated | % | Actual | % |  |  | Estimated | % | Actual | %
Revolving Bills |  |  |  |  |  | Monthly Expenses |  |  |  |  |  | Income
AES |  |  |  |  |  | Auto |  |  |  |  |  | AS pay
C.E. Rent |  |  |  |  |  | Clothing |  |  |  |  |  | C.E. Rent
Car Insurance |  |  |  |  |  | Entertainment
Discover Card |  |  |  |  |  | Food
Health Ins. |  |  |  |  |  | Gas
[NAME]'s |  |  |  |  |  | Household
M&I Loan |  |  |  |  |  | Medical
MBNA Card |  |  |  |  |  | Miscellaneous
Skype |  |  |  |  |  | C.E. Expenses
Sport & Health
Totals |  |  |  |  |  | Totals |  |  |  |  |  | Totals
2010-12-01 00:00:00
 |  |  |  |  |  | Est. Expenses | Expenses |  | Difference |  |  | Est. Income | Income |  | Difference
Total Expenses / Income
 | Estimated | % | Actual | % |  |  | Estimated | % | Actual | % |  |  | Estimated | % | Actual | %
Revolving Bills |  |  |  |  |  | Monthly Expenses |  |  |  |  |  | Income
AES |  |  |  |  |  | Auto |  |  |  |  |  | AS pay
C.E. Rent |  |  |  |  |  | Clothing |  |  |  |  |  | C.E. Rent
Car Insurance |  |  |  |  |  | Entertainment
Discover Card |  |  |  |  |  | Food
Health Ins. |  |  |  |  |  | Gas
[NAME]'s |  |  |  |  |  | Household
M&I Loan |  |  |  |  |  | Medical
MBNA Card |  |  |  |  |  | Miscellaneous
Skype |  |  |  |  |  | C.E. Expenses
Sport & Health
Totals |  |  |  |  |  | Totals |  |  |  |  |  | Totals