Results 1 to 5 of 5

Excel 2007 : Excel Calulations Question

Threaded View

  1. #1
    Registered User
    Join Date
    12-14-2010
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    5

    Angry Excel Calulations Question

    i have a membership spreadsheet with a Column in which i have ACT, AFF, LIFE, ASC membership titles, then in a column next to it i have there card numbers, i already use a countif statment to count how many ACT (active) members and so on that i have, what i would like to do is also calculate how many act have paid there dues. Hope you can help?

    So below we have 5 Life members, but only 3 paid. my first column would have the countif statement, but i want my second column to calculate how many paid.

    Stat Card #
    ACT 18751
    ASC 18752
    LIFE 18753
    AFF 18754
    LIFE 18755
    LIFE 18756
    LIFE
    LIFE
    Last edited by NBVC; 12-14-2010 at 02:37 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1