=SUM(IF(IF(MATCH(Table1[Ivoice],Table1[Ivoice],0)=ROW(Table1[Ivoice])-ROW(Table1[[#Headers],[Ivoice]]),(ROW(Table1[Ivoice])-ROW(Table1[[#Headers],[Ivoice]])),0)<>0,Table1[Totals],""))
Can someone break it down and explain the meaning behind the inputs please? What does the ROW function do in this formula?
Thank you!!!
Here is the table of data I used.
<colgroup><col><col></colgroup><tbody>
</tbody>
Can someone break it down and explain the meaning behind the inputs please? What does the ROW function do in this formula?
Thank you!!!
Here is the table of data I used.
Ivoice | Totals |
INV-000014 | 128 |
INV-000014 | 128 |
INV-000021 | 223 |
INV-000021 | 223 |
INV-000105 | 855 |
INV-000105 | 855 |
INV-000105 | 855 |
INV-000105 | 855 |
INV-000110 | 107 |
INV-000110 | 107 |
INV-000110 | 107 |
INV-000117 | 1546 |
INV-000117 | 1546 |
INV-000117 | 1546 |
INV-000118 | 998 |
INV-000118 | 998 |
<colgroup><col><col></colgroup><tbody>
</tbody>