Results 1 to 2 of 2

cell formulas

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 ...

  1. #1
    New Member
    Join Date
    Oct 2013
    Posts
    1

    Default cell formulas

    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.

    for instance,
    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?

  2. #2
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Redmond, WA
    Posts
    29,402

    Default Re: cell formulas

    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

    HTH,
    Smitty

    Every once in a while, there's a sudden gust of gravity...

    Check out my new book at the Mr. Excel Bookstore!

    Mr. Excel HTML Maker - Post a shot of your sheet

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com