Thread: Performing calculations in cells

Inside my deposit workbook are daily deposit sheets with the customer's checks broken down into detailed columns. i.e. deposit amount, taxable merchandise, taxable shipping, sales tax, non-taxable merchandise, etc...

The majority of time one check will pay multiple invoices with each invoice amount different. I presently use a calculator to total the amount for each cell, then enter that amount into the appropriate cell under the appropriate column. Is there a formula that I can utilize that will allow me to do the math in the cell itself? I am not at all familiar with macros but if one is required I would surely make use of it. I would very much appreciate it if someone could help me with this. Anyone familiar with QuickBooks will know what I am talking about.

A sample spreadsheet with some dummy data would make it easier to see what you need, and to help provide you with solution.

Your are absolutely right and I apologize for not doing that in the beginning. I made a copy of my working workbook and deleted any sensitive data. I am posting the entire wb not just a ss because of all the interaction of formulas between pages. Feel free to offer [U]any[U] constructive criticism to help me make this a better wb.