Welcome Guest
Log In | Register )
You last visited December 4, 2016, 1:02 am
All times shown are
Eastern Time (GMT-5:00)

Excell Help Wanted

Topic closed. 2 replies. Last post 4 years ago by dragon dreamer.

Page 1 of 1
PrintE-mailLink
Avatar

United States
Member #32007
February 6, 2006
57 Posts
Offline
Posted: October 2, 2012, 3:43 pm - IP Logged

I an trying to find a way to find how to count how many times a number showed in a spicific range, from a certain cell? 

Exemple:

Range:A1:G8

In cell H7, is the number I want to count,

I want the answer in cell H8.

If there is a better way of doing this please help.

Thank you in advance.

Dragon Dreamer

    Avatar

    United States
    Member #41846
    June 23, 2006
    458 Posts
    Offline
    Posted: October 2, 2012, 6:25 pm - IP Logged

    I an trying to find a way to find how to count how many times a number showed in a spicific range, from a certain cell? 

    Exemple:

    Range:A1:G8

    In cell H7, is the number I want to count,

    I want the answer in cell H8.

    If there is a better way of doing this please help.

    Thank you in advance.

    Dragon Dreamer

    the countif function does exactly what you asked for.

      Avatar

      United States
      Member #32007
      February 6, 2006
      57 Posts
      Offline
      Posted: October 2, 2012, 7:42 pm - IP Logged

      Thanks,

      Must have had a senior moment.

      Dragon Dreamer