Spreadsheet: 138802d1327916787-not-able-to-get-sum-of-my-values-in-a-coloumn-bcoz-of-null-value-n-a-in-d-same-colo-aif300112
Sheet: Sales Record

dd/mm/yy |  | dd/mm/yy
Date | Customer ID | Packed Date | No of Candy Packs | Delivered Packs Amount | Returned Packs Amount | Net [NAME] | Cash Received Part 1 | Cash Received Part 2 | Total Cash Received | Pending Cash | Returned Candy Packs
2012-01-01 00:00:00 | 001-001 | 2012-01-01 00:00:00 | 5 | 50 | 0 | 50 | 50 |  | 50 | 0 |  |  | Total Candy Packs Sold in this month |  |  |  | 291
2012-01-01 00:00:00 | 001-003 | 2012-01-01 00:00:00 | 10 | 80 | 0 | 80 | 80 |  | 80 | 0 |  |  | Total Candy Packs Returned |  |  |  | 3
2012-01-01 00:00:00 | 001-007 | 2012-01-01 00:00:00 | 20 | 200 | 0 | 200 | 200 |  | 200 | 0 |  |  | Total Net [NAME] |  |  |  | 3111
2012-01-01 00:00:00 | 001-008 | 2012-01-01 00:00:00 | 10 | 120 | 0 | 120 | 120 |  | 120 | 0 |  |  | Total Cash Received |  |  |  | 3111
2012-01-01 00:00:00 | 001-015 | 2012-01-01 00:00:00 | 5 | 60 | 0 | 60 | 60 |  | 60 | 0 |  |  | Total Pending Cash |  |  |  | 0
2012-01-01 00:00:00 | 001-012 | 2012-01-01 00:00:00 | 7 | 63 | 0 | 63 | 63 |  | 63 | 0
2012-01-01 00:00:00 | 001-019 | 2012-01-01 00:00:00 | 25 | 300 | 0 | 300 | 300 |  | 300 | 0
2012-02-01 00:00:00 | 001-002 | 2012-01-01 00:00:00 | 15 | 150 | 0 | 150 | 150 |  | 150 | 0
2012-02-01 00:00:00 | 001-005 | 2012-01-01 00:00:00 | 5 | 60 | 0 | 60 | 60 |  | 60 | 0
2012-02-01 00:00:00 | 001-004 | 2012-02-01 00:00:00 | 10 | 120 | 0 | 120 | 120 |  | 120 | 0
2012-02-01 00:00:00 | 001-020 | 2012-02-01 00:00:00 | 7 | 84 | 0 | 84 | 84 |  | 84 | 0
2012-03-01 00:00:00 | 001-018 | 2012-01-01 00:00:00 | 5 | 40 | 0 | 40 | 40 |  | 40 | 0
2012-03-01 00:00:00 | 001-017 | 2012-02-01 00:00:00 | 3 | 33 | 0 | 33 | 33 |  | 33 | 0
2012-03-01 00:00:00 | 001-011 | 2012-03-01 00:00:00 | 5 | 55 | 0 | 55 | 55 |  | 55 | 0
2012-03-01 00:00:00 | 001-006 | 2012-03-01 00:00:00 | 7 | 84 | 0 | 84 | 84 |  | 84 | 0
2012-03-01 00:00:00 | 001-004 | 2012-03-01 00:00:00 | 10 | 120 | 0 | 120 | 70 | 50 | 120 | 0
2012-04-01 00:00:00 | 001-001 | 2012-04-01 00:00:00 | 10 | 100 | 20 | 80 | 80 |  | 80 | 0 | 2
2012-04-01 00:00:00 | 001-003 | 2012-04-01 00:00:00 | 5 | 40 | 0 | 40 | 40 |  | 40 | 0
2012-04-01 00:00:00 | 001-007 | 2012-03-01 00:00:00 | 10 | 100 | 10 | 90 | 90 |  | 90 | 0 | 1
2012-04-01 00:00:00 | 001-008 | 2012-04-01 00:00:00 | 5 | 60 | 0 | 60 | 60 |  | 60 | 0
2012-04-01 00:00:00 | 001-015 | 2012-04-01 00:00:00 | 10 | 120 | 0 | 120 | 120 |  | 120 | 0
2012-04-01 00:00:00 | 001-012 | 2012-04-01 00:00:00 | 5 | 45 | 0 | 45 | 45 |  | 45 | 0
2012-05-01 00:00:00 | 001-002 | 2012-05-01 00:00:00 | 5 | 50 | 0 | 50 | 50 |  | 50 | 0
2012-05-01 00:00:00 | 001-005 | 2012-05-01 00:00:00 | 5 | 60 | 0 | 60 | 60 |  | 60 | 0
2012-05-01 00:00:00 | 001-004 | 2012-04-01 00:00:00 | 5 | 60 | 0 | 60 | 60 |  | 60 | 0
2012-05-01 00:00:00 | 001-020 | 2012-05-01 00:00:00 | 20 | 240 | 0 | 240 | 240 |  | 240 | 0
2012-06-01 00:00:00 | 001-018 | 2012-06-01 00:00:00 | 5 | 40 | 0 | 40 | 40 |  | 40 | 0
2012-06-01 00:00:00 | 001-017 | 2012-06-01 00:00:00 | 10 | 110 | 0 | 110 | 110 |  | 110 | 0
2012-06-01 00:00:00 | 001-011 | 2012-06-01 00:00:00 | 7 | 77 | 0 | 77 | 77 |  | 77 | 0
2012-06-01 00:00:00 | 001-006 | 2012-06-01 00:00:00 | 5 | 60 | 0 | 60 | 60 |  | 60 | 0
2012-06-01 00:00:00 | 001-004 | 2012-06-01 00:00:00 | 15 | 180 | 0 | 180 | 180 |  | 180 | 0
2012-06-01 00:00:00 | 001-002 | 2012-06-01 00:00:00 | 10 | 100 | 0 | 100 | 100 |  | 100 | 0
2012-06-01 00:00:00 | 001-003 | 2012-06-01 00:00:00 | 10 | 80 | 0 | 80 | 80 |  | 80 | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0