COUNTIF DATA IN A ROW IF VALUE CHANGES

Question

I have a row of numbers that I use the COUNTIF function to display the number of times the value exceeds 153.9, =COUNTIF($B$156:$GS$156,">153.9") and it works great. In that row I want to at a different starting point only count the number of time the value exceeds 152.9. I tried using COUNTIF($B$156:$GS$156,">153.9",$EA$156:$GS$156,">152.9") to start counting both times the values exceeds 153.9 from B156:DZ156 dz156 and 152.9 from EA156:GS156.

So the question is how many times does the row have a value that exceeds 153.9 up to a certain point and then only add the number or times it exceeds 152.9 in the rest of the row.

Answer 1

Please try V_Agarwal's formula, that should work for your case.

Answer 2

Works great!! Thanks

Answer 3

I'll try. I record my maximum heart rate when I exercise. At age 66 the max is 154, at age 67 the max drops a point to 153. I record the max heart rate in row 156 for a entire year. At the point of my birthday (Oct 19) the max rate becomes 153. I want to count the number of times I exceed the max rate up to my birth date and then count the number of times it exceeds the new rate of 153 at age 67 and add both of them together to know the number of times I have exceeded the max rate for those two time periods.

Answer 4

Try,

=COUNTIF($B$156:$DZ$156,">153.9")+COUNTIF($EA$156:$GS$156,">152.9")

Answer 5

Hi,

I cannot visualize your requirement.  Please explain again.