+ Reply to Thread
Results 1 to 2 of 2

Counting the number of added values in a cell

  1. #1
    Registered User
    Join Date
    01-08-2022
    Location
    LA
    MS-Off Ver
    365
    Posts
    1

    Counting the number of added values in a cell

    Hey guys, first time posting here. I have an excel sheet where i add numbers, for example in a cell i will type =12+12+15
    after i push enter, the cell will read 39.
    Later i want to have another cell output the number 3, which counted the number of numbers i previously added. Is this possible? Every function i find works on the 39, but how do i get a cell to output the number 3 in this example.

    Thanks for your help, i really appreciate it.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: Counting the number of added values in a cell

    For the specific example:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. [SOLVED] Need cell to be a number when a word is chosen from a dropdown and then added to other cel
    By Compliance Queen in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-02-2018, 03:28 PM
  2. Replies: 2
    Last Post: 02-24-2017, 03:42 PM
  3. Cell not adding number and remembering last number added
    By taichi56 in forum Access Tables & Databases
    Replies: 4
    Last Post: 12-03-2015, 10:18 PM
  4. Counting number of values within a date range equal or great to a number
    By diablo_719 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-15-2013, 02:55 PM
  5. Replies: 3
    Last Post: 03-29-2011, 11:03 AM
  6. Counting number of items being added in a formula
    By Lambtwo in forum Excel General
    Replies: 14
    Last Post: 11-03-2005, 01:25 PM
  7. Replies: 0
    Last Post: 08-25-2005, 05:52 AM

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