Total data entered semi-monthly

**bexr2015** · 07-25-2015, 01:18 PM

I have a huge spreadsheet where we keep a running "ledger" on each employee on a different tab. These individual tabs keep a running total for each employee's payroll. We pay on a semi-monthly basis and each payroll, I need to get a total of each person's pay for that particular pay period. I am currently going through each tab and adding them manually on a calculator. I am looking for a formula or something that will automatically do it for me. So each time I go in to add pay to their tab, it takes THAT total to a different tab and keeps a list of that payroll's total. Not sure if all that makes sense of not....

**prabhuduraraj09** · 07-25-2015, 01:24 PM

Hi,

if you could provide sample file. Then i could try update formula for you.

**bexr2015** · 07-25-2015, 01:43 PM

Ledger replacement.xlsxHere is a sample. In this workbook, we add in the person's pay each 10th and 25th of the month. I need the total every payroll. How do I get that without having to manually add?

**oeldere** · 07-25-2015, 02:16 PM

Please also add manualy the expected result in your file. Mark the related cells e.g. with the same color.

**MarvinP** · 07-25-2015, 02:32 PM

Hi bexr and welcome to the forum,

Excel works best in TABLES of data. I took your first two tabs and made a table of the data on Sheet 1. Then I did a very easy and simple Pivot Table to get what I think you want. You have merged cells between Col A and B on your employee tabs that really hurts the conversion. You also shouldn't have blank rows (or columns) in a table. I'd restructure your data to look like sheet 1 if you want to get your question answered. See the attached.