Include OR statement in COUNTIF?

[PhDScience]

Hello,

I have a set of data as attached. Data_Calculation.xlsx

Column I denotes velocity data for each time-point (in seconds), as per Column D. Column H indicates a velocity threshold, that being, if the raw velocity data (located in B) is between particular velocity bands (cells B13 and C13, respectively), a 1 is placed in cells of Column G. If there are two consecutive 1's in column G, column H will print a 1 in the cell. If this condition is not met, a 0 will be placed. Further, if a 1 exists in a cell in Column H, the velocity distance from F3 will be printed. Cell I12 indicates the total distance completed in this velocity band.

However, this total distance is incorrect, as the first recorded distance in the threshold is not included. For example, G4, is still distance traveled over this threshold and contributes to a minimum of two consecutive cells.

Currently, I have in Column I, =IF(COUNTIF(H3,"1"),F3,"")
Is there a way of incorporating an OR statement so that if the above is false, it next looks in H4 and if there is a 1 in this cell, the data in F3 is printed in I3?

Any help would be greatly appreciated.

Thank you!

[benishiryo]

hi there. do you mean this?
=IF(OR(COUNTIF(H3,1),H4),F3,"")

you could remove the double quotes for the 1 since it's a number. and to help us understand better, you can always type the answers you hope to see in Column I. the above chunk of info you provided are mostly unnecessary. this portion will do:

Currently, I have in Column I, =IF(COUNTIF(H3,"1"),F3,"")
Is there a way of incorporating an OR statement so that if the above is false, it next looks in H4 and if there is a 1 in this cell, the data in F3 is printed in I3?

[PhDScience]

Thank you so very much, benishiryo.

That formula worked perfectly.

Apologies for all the unnecessary information, the last thread I created was too brief initially, so thought it best to explain the data.

Thank you!