Please write myself and other users a simple macro

[diy]

Ok so here is the situation. I use Intuits POS software and their merchant service. Myself, as well as other users of these products have one heck of a time reconciling credit card deposits with the bank. The way the software and the merchant service pairs up transactions can make it a guessing game to get things straight. I would say I am a slightly above average user of excel, but I openly admit this is over my head.

The highlighted yellow portion in the book is what the transactions look like when downloaded. What I need is to sum of Visa, MC, DISC individually. From each deposit. I have used some "If" formulas to organize the data in the columns and leave some row of "" blanks when I need the sums in the red boxes. I have done this by clicking the box and pressing auto sum which works fine. But I would like is a formula or macro that will automatically sum these figures once the data is put in the workbook.

Traditional formulas cannot work in this case, (or at least I am not sure how to create them) because the number of transactions changes the cells that need to be summed each time.


Thanks in advance.