I need formula help

[j5b9]

I Need a formula - I have a string of numbers I need to count how many times, the the top # minus the next # is > than .05

String
P37:P63
------
-0.13
-0.15 -.02 = -.15 to -.13
-0.15 0 = -.15 to -.15
-0.16 -.01 = -.16 to -.15
-0.17 -.01 = -.17 to -.16
-0.01 .16 = -.01 to -.17 Counts 1
-0.02 -.01 = -.02 to -.01
-0.05 -.03 = -.05 to -.02
-0.07 -.02 = -.07 to -.05
0.01 .06 = .01 to -.07 Counts 2
Ect....

 

[Deuce Bucksman]

Are you looking for a nested formula? You could always have data stringing across multiple columns, and in the last column use a countifs >.5 formula. Sorry, i'm just not sure what you're looking for.

 

[j5b9]

I dont know the meaning of Nested I need a formula that will check all lines for the value greater than .05,
and count the total cells greater than .05

String
P37:P63
------
-0.13
-0.15
-0.15
-0.16
ect...

-.15 (p38) to -.13 (p37)= -.02
-.15 (p39) to -.15 (p38)= 0
-.16 (p40) to -.15 (p39)= -.01 when the answer is = to or over .05

I needed a count of the ones only = to or over .05

Hope that clears it up!

 

[Deuce Bucksman]

A nested cell is simply using more than one function. For example, using if and or together. For what you are looking for, this should do the trick:


If you are only looking for one output, then use the following:
=COUNTIF(I11:I14,">.05")

That will return one number in the range for all the cells that are greater than .05. if you just want a count for each cell, use the following:

IF(I11>0.05,1,"") and drag this down. For this you'll need to drag down so they will autofill, this will return a value of 1 if the condition is met (more than .05), or nothing if it is not met. After that, simply sum and you are good to go.