This formula is intended to calculate the sequence of positive numbers from Q4:Q60, but is calculating Q4:Q60 blanks produced by another formula as a positive number, so instead of counting a sequence of 4positive numbers is counting 36 including blanks. I want to change this formula to ignore blanks from Q4:Q60?
"=MAX(FREQUENCY(IF(Sheet1!Q4:Q60>0;ROW(Sheet1!Q4:Q60));IF(Sheet1!Q4:Q60<=0;ROW(Sheet1!Q4:Q60))))"
Bookmarks