Count values on a row that are within, equal to or greater than a value in row within the same column

  • Hello


    i hope someone can help with this.


    essentially i want to count all instances on a row where the number on that row is either within 0.5, equal to, or greater than the number on row 2 of the same column


    i have attached a sample file that shows how the data is laid out and what i would expect / like to see in column J


    i appreciate this is not the most efficient way to lay the data out and if i reformatted it, it would make it easier however this ius not something i am able to control as i am not the owner of the sheet.


    Thanks in advance for any help

  • Hi,


    Once you have tested the formula ... feel free to share your comments

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Thank you very much for this it works perfectly.


    also apologies for not replying i know that may appear rude but i had some urgent personal issues which pushed this to the back of my mind.


    the help is appreciated

  • Glad this could fix your problem :thumbup:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!