_:n231a4ab5beaf483ea3279f353fc4377dxb1
<http://schema.org/text>
"Hi there\r\n\r\nMy question basically boils down to payment / invoice match.\r\nIn one column I have amounts (paid or invoice - often one payment will include more invoices) on the other column I have the number which links invoices to payment and it should equal zero.\r\nExample\r\n\r\nColumn N                   Column P\r\n843.43-                     17002179\r\n3872.46-                   17002179\r\n905.69-                     17002179\r\n5624.55                    17002179\r\n\r\nI'd like to sum amounts in N when they have the same reference cell on P. I've tried the sumif perhaps not well because there are too many variables in P.\r\nThank you in advance for you help\r\nMarco"
<https://ccm.net/forum/affich-700051-sum-numbers-in-a-column-by-corresponding-number>