+ Reply to Thread
Results 1 to 5 of 5

Need help with a tally formula

  1. #1
    Registered User
    Join Date
    10-10-2013
    Location
    Center Line, Mi
    MS-Off Ver
    Excel 2007
    Posts
    3

    Need help with a tally formula

    I am new to this community and have been searching for a formula that would create a button. What I would like the button to do is to add +1 to a cell. I have been scouring everywhere for an answer. The objective of the chart is to add 1 to a designated cell for counting needle and thread breaks. I completely forgot the route to go about it. Also this may help as well...I am using Polaris office 2007 and excel 2007 on the Polaris office software. I am unsure if the function even exists as I am fairly new to Polaris office and unsure of how far it can go. If anyone can assist with a tally formula I would most appreciate it. I will keep plugging away at it though and will reply if I figure it out.

  2. #2
    Forum Contributor
    Join Date
    10-01-2013
    Location
    Cameron, Mo
    MS-Off Ver
    Excel 2010
    Posts
    113

    Re: Need help with a tally formula

    I am constantly amazed by the creativity I see in people so saying something won't work is never easy to do, but I don't think Polaris can support what you attempting. The reason is this. Button with assigned functions in Excel use VBA to execute their tasks. To my knowledge software like Polaris and Kingsoft can do formulas, but do not have VBA as part of there features. I could be wrong on this one. I hope this gets you closer to your answer! Good luck

    P.S. If you want to do this in just excel it is possible with a macro.

  3. #3
    Registered User
    Join Date
    10-10-2013
    Location
    Center Line, Mi
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Need help with a tally formula

    Thank you very much. I had a bad feeling about the Polaris not being able to do it. Only leaves one other option...a PC lol. Maybe they will update one day though.

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Need help with a tally formula

    Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

    In future, to mark your thread as Solved, you can do the following -
    Select Thread Tools-> Mark thread as Solved.

    Incase your issue is not solved, you can undo it as follows -
    Select Thread Tools-> Mark thread as Unsolved.

    Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  5. #5
    Registered User
    Join Date
    10-10-2013
    Location
    Center Line, Mi
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Need help with a tally formula

    Oh okay sorry about that. Thank you for doing it for me this time. I will remember in the future.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. formula look up deleting duplicates and tally
    By ellenpost in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-20-2013, 10:22 AM
  2. How do I write a formula to tally class participation
    By gr8rcfan in forum Excel General
    Replies: 12
    Last Post: 12-30-2011, 07:45 PM
  3. Replies: 2
    Last Post: 11-06-2011, 11:01 PM
  4. create tally sheet for positions- insert names and tally #
    By tally sheets in forum Excel General
    Replies: 0
    Last Post: 04-11-2006, 04:45 PM
  5. [SOLVED] How do you set up a tally?
    By caaddream in forum Excel General
    Replies: 0
    Last Post: 03-09-2006, 06:50 PM

Tags for this Thread

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