Countif offset formula comparing 2 values in same column
<p>Need help with a formula that will count a value only if it's 3 rows below a different value. Both values are in Column c. Example.  "Value1" is listed 5 times. So I have a countif for a total of 5.  2 times it is 3 rows below "value2".  I want a formula that will count  "value1" only if it's 3 rows below "value2".  So my formula would generate "2". I have a offset countif but I cannot get it to condition based on "value2"</p>