Formula to count if cells in consecutive columns are populated

[Closed]
Report
Posts
6
Registration date
Monday October 28, 2013
Status
Member
Last seen
October 31, 2013
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I need an equation that will return a 1 in column F if data is available (cell is populated) in 2013 or last two years (2012 & 2013) or last three years (2011 & 2012 & 2013) or last four years or last five years. A zero counts as data.

Data is set up as:
Years in columns

2009 2010 2011 2012 2013 Count
product 1 34 32 33 31 35 1
product 2 40 1
product 3 15 16 15
product 4 66 67 1
product 5 55 67 78 1
product 6 90 1
product 7 26 27 26 27
product 8 54 64 74 84 1
product 9 87 98 99

Thank you!

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
criteria not clear.
producst only first year so shd it not be zero

product 4
2013 no
last two no
last three no
last four no
lasts five no
why shd be 1

reprase the critiera