counting of consecutive days over a certain value

J

joe

Hello all, i have a request for you. i have a spreadsheet that is all layed
out with upto 31(days of month) columns and 50+ rows. my problem is this! i
need a formula that will count the number of days starting with today and
looking backwards to prior days that have a value of >=.26 and will give a
result in a column at the end of the string?

example 1:

starting with C6:AG6 the values are as follows
0.13 0 0.21 0.27 0.11 0.31 0.42 0.13
above count would be 0 - 0 1 0 0 1 2 0

example 2 c10:ag10

0.37 0 0.46 0.55 0.3 0.32 0.21 0.19
above count would be 1 - 2 3 4 5 6 0 0

example 3 c26:ag26
0.72 0 0.59 0.23 0.41 0.3 0.35 0.35
above count would be 1 - 2 0 1 2 3 4

example 4 c32:ag32

0.28 0 0.39 0.07 0.28 0.59 0.25 0.29
above count would be 1 - 2 0 1 2 0 1

the dash represents a day where no data is expected thus the count is
continued from the previous day if over the >=.26 benchmark.

thanks for your continued support
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top