Formula to count if cells in consecutive columns are populated

Closed
nycm Posts 6 Registration date Monday October 28, 2013 Status Member Last seen October 31, 2013 - Oct 31, 2013 at 05:42 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 1, 2013 at 01:55 AM
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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 1, 2013 at 01:55 AM
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
0