Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Need Help With Excel Coding

  • 06-12-2011 05:17PM
    #1
    [DM]Frink
    Registered Users, Registered Users 2 Posts: 61 ✭✭


    Hey can someone please help me I am trying to right a little program in work. I work in retail and am basically trying to see how often the tills are off. At the moment I have a count going for that but I need to count the amount of times they are in work.

    Day Monday Tuesday
    28/11/2011 29/11/2011
    Name - Days Worked -Times Tills Down -

    Mr x ? 1 -5.98 +3.46

    So I have a count going for how many the tills are down using =COUNTIF(H6:DV6,"<0")
    But I dont know how to count basic, if there is a number in a cells add one, because some days the staff arent working so I can only count it when there is a value in the cell.

    Can anyone help me it would be great!


Comments

  • #2
    carveone
    Registered Users, Registered Users 2 Posts: 1,346 ✭✭✭carveone


    There's a hash symbol on the toolbar which wraps CODE tags around stuff you want left alone by the way. Cause it's a bit difficult to see what you are trying to do...

    A lot more people in the Windows forum know about excel. But are you trying to do something like: if there is a number in a cell and the cell isn't blank, then add one to some other cell?


  • #3
    carveone
    Registered Users, Registered Users 2 Posts: 1,346 ✭✭✭carveone


    ...because COUNT does that:
      =COUNT(A1:A5)

    If 3 of the cells from A1 to A5 contain numbers and 2 contain text then the above will return 3, the number of cells that contain numbers.


  • #4
    [DM]Frink
    Registered Users, Registered Users 2 Posts: 61 ✭✭[DM]Frink


    Thanks......COUNT worked!!!


Advertisement