You’re offline. This is a read only version of the page.
Announcements
23
Hi guys,
I have extracted a datatable from excel which has all the values that I need. My goal is to calculate the sum of all values present in Column H (Amount in local currency) and the sum of all the values present in Column I (Arrears after net due date), with respect to the names in Colum C (Name 1).
The names can be anywhere in the excel table.
Example Table:
| Customer | Name | Net due date | Amount in local currency | Arrears after net due date |
| 1000 | Name 1 | 2/4/2006 | 1000 | 10 |
| 1001 | Name 2 | 4/23/2010 | 500 | 5 |
| 1002 | Name 3 | 5/16/2015 | 2000 | 15 |
| 1000 | Name 1 | 2/10/2006 | 1000 | 10 |
| 1001 | Name 2 | 2/4/2006 | 500 | 5 |
| 1002 | Name 3 | 8/26/2013 | 2000 | 15 |
Required Output:
| Customer | Name | Net due date | Amount in local currency | Arrears after net due date |
| 1000 | Name 1 | 2000 | 20 | |
| 1001 | Name 2 | 1000 | 10 | |
| 1002 | Name 3 | 4000 | 30 |
Share
Report
All responses (
Answers (
