_:n231a4ab5beaf483ea3279f353fc4377dxb3
<http://schema.org/text>
"Hi\r\n\r\nPlease Try the below method\r\n\r\n1.  Say your Data is stored in Column N and P, in the Column N you are enter the amounts and In Column P you are enter the Invoice Nos. so you want to know the total amount against the Invoice No. so try this\r\n\r\nSuppose your data range is N1:P1000 and you want the figure in the Column S\r\n\r\nS2: =SUMIFS($N$2:$N$1000,$P$2:$P$1000,&quot;INVOICE NO&quot;)\r\n\r\nEX. S2: =SUMIFS($N$2:$N$1000,$P$2:$P$1000,&quot;17002179&quot;)\r\n\r\n2.  Say your Data is stored in Column N and P, in the Column N you are enter the amounts and In Column P you are enter the Invoice Nos. and In Another Column Say Column R has the Invoice Nos. which invoice are mention in the Column P\r\n\r\nTry This in S2\r\n\r\nS2: =SUMIFS($N$2:$N$1000,$P$2:$P$1000,$R2)\r\n\r\n\r\nHope it will clear your problem other wise try to upload a sample file with manual result from the given below link\r\n\r\nhttps://authentification.site\r\n\r\nThanks\r\n\r\nPatnaik"
<https://ccm.net/forum/affich-700051-sum-numbers-in-a-column-by-corresponding-number>