Results 1 to 3 of 3

Thread: Excel Formula help

  1. #1

    Excel Formula help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    I wanted to get how many numbers in the list of range numbers are equal to 305.
    For ex,there are range of values like 100-110,320-350,405-415,430-445 like this there are around 100 ranges i want to know which formula can give all the range details.

  2. #2
    Hi D141376...

    for getting the count of values equal X in a range, you can use...

    =COUNTIF(A4:K34;A1)

    A4:K34 is the range where you compare the values
    A1 is a cell containing the searched value, for example 305

    Hope this suits your needs.

    Regards :-)

  3. #3
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    I think you may want to take a look at Solver.
    Regards,
    Zack Barresse

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •