This is a discussion on cell formulas within the Excel Questions forums, part of the Question Forums category; ok, i'm creating a simple spreadsheet to keep tally of membership dues. and i don't know what formula to use ...
ok, i'm creating a simple spreadsheet to keep tally of membership dues. and i don't know what formula to use in the cells where i insert the amount the member paid.
if member paid $2 on one day.
and $2 on the other day.
i wanna be able to go to the spread sheet and just enter what they give me so the number in the cell will change to the running total.
and at the end of the month i can total for each member in another cell...
is that clear?
Welcome to the Board!
Sounds like a good job for a Pivot Table. Here's a good tutorial: Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one | Chandoo.org - Learn Microsoft Excel Online