Debit - Credit - Balance

[CrazynWild]

Hi Everyone,

I was wondering if someone could help me. I am managing funds for small group of people for charity. My Excel skills are very basic so I thought I'll post my question here to get some help.

I have 10 members in the group, each member pays small amount of money on weekly basis. I have created 10 different sheets in a workbook to keep a track of funds paid by each member. The funds are then reconciled at the end of each month as total collection from all the members.

However recently one of the member has become bit irregular in payments and some times pays in advance as lump sum or falls behind.

My issue lies that I need to get the results in Balance column accordingly on weekly basis. For example if this member pays one week in advance as lump sum or pays additional funds to cover extra weeks the running balance should show as credit or if this member falls behind week or two then the running balance should be in Debit until the payments are made to bring the balance to nil

I would appreciate if someone could post a formula here that can help me achieve the result as described above.

I hope I am making any sense.

Thank you so much in advance

CrazynWild

[nathansav]

I wouldnt have 10 sheets. With data always think how you'll structure it for success, that is if it works and is utilised say by a company with 1000 members.

Excel has many rows and many columns, so a one sheet piece for this would be perfect. So combine all 10, but add an extra column for the owner. You can cut & Paste the 10 in to 1.

so
A B C
Name Date Payment


then you can say in a summary sheet

A1="Tom"

=sumif('SheetData'!C:C,'SheetSummary'!A1)

something like that, i am not in excel at the minute.