WERNER SLABBERT
Board Regular
- Joined
- Mar 3, 2009
- Messages
- 104
Ref | Company | Date | Company | INV Number | Sub Total | Expenses | Difference | Grand Total | Paid | Credit Status | Date Sum | Outstanding Amount | Sum by Date | ||
1 | Test | 2018/10/03 | Test 2018/10/03_Test0001 | Test0001 | R3 888,00 | R2 110,00 | -R 4 002,00 | R 5 998,00 | Yes | OPEN | -R 4 002,00 | 0,00 | 43377 | 43376 | |
2 | test | 2018/10/03 | test 2018/10/03_yrgcbgvbcvb | yrgcbgvbcvb | R64 320 750,00 | R32 456,00 | R 59 763 506,00 | R 64 353 206,00 | No | R 59 763 506,00 | 0,00 | 43376 | |||
3 | asdfghjkl | 2018/10/04 | asdfghjkl 2018/10/04_asdfgh45678 | asdfgh45678 | R129 925 025,00 | R234 567 890,00 | R 361 036 126,00 | R 364 492 915,00 | No | R 361 036 126,00 | 0,00 | 43377 |
<tbody>
</tbody>
How do i get the "Sum by Date" (Column "O" or SBD ) to sum all the rows in "Grand Total" (Column "J" or GrndTot ) that has the same date in "Date" (Column "D" or DT ) and only show result in the last row that has the specific date , this has to apply to 10 000 rows and dates an rows might change.
I have tried my hand at the SUMIFS [ =SUMIF(DT;$P$8;GrndTot) ]
any help would be appreciated alot. i've been stuck here for about 2 weeks now.
PS: The last two columns are just the date selector ( date in excel years) and the date from DT (in excel years)
Last edited: