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!

    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...


    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
    Oregon, United States
    I think you may want to take a look at Solver.
    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