Count Cells Within 10 of a Cell Value

M

Missbrooke06

I need a formula that calculates how many out of a range of cells are within
10 of another cell. For instance, I have cells F3 through U3. I want to know
how many of them are either 10 above or 10 below the value in cell V3. If
cell V3 equals 20, than I want to know how many are between 10 and 20 and how
many are between 20 and 30. Ideally, this would be in the same formula but
two seperate formulas is also acceptable.
 
M

Mike H

Hi,

Try this

=COUNTIF(F2:U2,">="&V2/2)-COUNTIF(F2:U2,">"&V2*1.5)

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
Finding the proper style field and the numbered paragraph value within the style 0
Is there a function to count how many times a cells value is used? 0
How can i find the max value within a time range ased on two cells 6
Excel Countif Function - Calculating Between Two Sets of Values 3
Word macro that can call cells out of Excel for a find and replace 0
Help With Formula For Cell Addresses 2
Show a cell's formula in text format in a linked cell 2

Top