Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Help - Count

  • 01-06-2010 8:56am
    #1
    tonyagrey
    Registered Users, Registered Users 2 Posts: 63 ✭✭


    Guys,

    Another bit of help needed on this one. Please see example table below.

    I want to be able to do a count of the number of weeks that have passed since an account has first purchased from me. eg. 3 weeks have passed since Acc1 first purchased from me. 2 weeks have passed since Acc2 has purchased from me.

    Any help would be greatly appreciated!

    Week 1 Week 2 Week 3
    Acc1 2 2 1
    Acc2 1
    Acc3 3


Comments

  • #2
    phog
    Registered Users, Registered Users 2 Posts: 24,968 ✭✭✭✭phog


    Would countif do it for you.

    Also, if you drag your mouse over the cell in the relevant row or column the count of cell with data will appear in the status bar at the bottom of the worksheet.


  • #3
    KAGY
    Registered Users, Registered Users 2 Posts: 1,093 ✭✭✭KAGY


    tonyagrey wrote: »
    Guys,

    Another bit of help needed on this one. Please see example table below.

    I want to be able to do a count of the number of weeks that have passed since an account has first purchased from me. eg. 3 weeks have passed since Acc1 first purchased from me. 2 weeks have passed since Acc2 has purchased from me.

    Any help would be greatly appreciated!

    Week 1 Week 2 Week 3
    Acc1 2 2 1
    Acc2 1
    Acc3 3

    You won't be able to do this with one single formula unless you start creating macros. However, a workaround would be to create a new table either below your data or on another sheet.
    The formula in column B is =IF(ISBLANK(B2);1;0)
    The formula in columns C and after is =IF(ISBLANK(C2);B9+1;0)
    <edit> the formula I used are for open office, replace the ; with , for excel</edit>
    A B C D
    1 Week1 Week2 Week3
    2 Acc1 2 2 1
    3 Acc2 3 1
    4 Acc3 1
    5 Acc4 1
    6
    7 Number of weeks since last purchase
    8 Week1 Week2 Week3
    9 Acc1 0 0 0
    10 Acc2 0 0 1
    11 Acc3 0 1 2
    12 Acc4 1 0 1
    13




Advertisement