troubleshooting Question

Excel Sheet

Avatar of sammySeltzer
sammySeltzerFlag for United States of America asked on
Microsoft ExcelMicrosoft Office
9 Comments1 Solution91 ViewsLast Modified:
Dear experts,

I have some challenge that i am having difficulty designing.

I have an organization that wtith membership (of course).

Each member is required to pay on an annual basis $120.00

So, the base annual duess $120.00

Beginning from 2014, each year should have two columns, one shows how much each member has paid his/her $120.00 dues.

The second column (again for each year) should show how much is left.

For instance, 2014, member pays $60.00 on one column and the other column for 2014 shows the remaining $60.00 to be paid.

Even though the year begins in 2014, it span up to 2050.

There are also miscileanous events such as fund raising. This could occur at any year.  That even should show how much a member pledged to pay, how much is paid and how much is left to pay.

Eventually, the total paid and the total remaing should show horizontally and then vertically.


John Doe pays $60.00 out of annual dues of $120. Then John Doe pledges to pay $100.00 for fund raising and pays $0.00.

At far right will be a total of $60.00 and total of $160.00 by John Doe.

Then at bottom shows total paid for each year and total owed

Can someone please suggest the best way to design the excel spreadship to accommodate this requirement?

Attached spreadsheet shows sample of what I am trying to accomplish.

Thanks a lot for your assistance.
Dustin Saunders
Co-Founder and Chief Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Top Expert 2016

The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.

Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros