I'm using SUMIF to get the gross for each person and list them separately, but I want to extend it to only Sum the totals over $100.00 on Column B to put into Column F, and to only count the amounts also over $100 for Column H.
The VBA portion that Sums the total for Column F is :
How can I re-write it so that it only Sums & counts the entries on Column B, and to fill in Column I & J ?Range("F2:F" & Endrow).Formula = "=SUMIF(A:A,E2,B:B)"
See the Attached .xls sheet
Reply With Quote