I want to add the amounts in column M (total) for each deposit number in Column B.
For example, Dep #1041 (B5 and B6), the total for this deposit number (197.1+49.29=246.39). I only want ONE amount for each deposit number. I want to be able to drag this formula for all other deposit numbers.
(I did =SUMIF(B5:B16,B5,M5:M16), but it gives me 49.29 for row 6. I want only once 246.39 for both rows).