+ Reply to Thread
Results 1 to 5 of 5

Giving Cells Numerical Values

Hybrid View

  1. #1
    Registered User
    Join Date
    05-13-2021
    Location
    United States
    MS-Off Ver
    2016
    Posts
    5

    Question Giving Cells Numerical Values

    Hello! I have a list of events that happened in column A and the dates they happened in their corresponding B column. Is there a way for me to be able to have a cell at the bottom that would have the total number of events?

  2. #2
    Valued Forum Contributor
    Join Date
    05-15-2017
    Location
    US
    MS-Off Ver
    365
    Posts
    901

    Re: Giving Cells Numerical Values

    you can use COUNT

    =COUNT(A4:A27)

    Replace with your range

    But it would be helpful if you could provide a sample file that others can use to assist.
    If you find the suggestion or solution helpful, please consider adding reputation to the post.

  3. #3
    Registered User
    Join Date
    05-13-2021
    Location
    United States
    MS-Off Ver
    2016
    Posts
    5

    Re: Giving Cells Numerical Values

    Hello!
    I tried COUNT and replaced with my range and it did not work. Here is a sample file I created that is similar to what I need done.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    05-13-2021
    Location
    United States
    MS-Off Ver
    2016
    Posts
    5

    Re: Giving Cells Numerical Values

    NVM, Got it!

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2406 Win 11 Home 64 Bit
    Posts
    23,982

    Re: Giving Cells Numerical Values

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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] Giving letters numerical value and calculation with them
    By fedaykin92 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-11-2019, 04:42 AM
  2. Giving text a numerical value
    By KillieAndy87 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-25-2018, 03:21 PM
  3. Giving grades a numerical value
    By josh60 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-24-2016, 06:32 PM
  4. Giving a letter a numerical value
    By imnotgoodatexcel in forum Excel General
    Replies: 20
    Last Post: 04-08-2014, 08:47 PM
  5. [SOLVED] Giving Text a Numerical Value
    By ryanklein in forum Excel General
    Replies: 4
    Last Post: 03-21-2006, 11:35 PM
  6. Giving a letter a numerical value
    By Mullet2262 in forum Excel General
    Replies: 5
    Last Post: 03-08-2006, 09:23 PM
  7. Giving Months Numerical Values
    By luvthavodka in forum Excel General
    Replies: 1
    Last Post: 12-09-2005, 07:00 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