Conditional If then to return values for ranges

[#1]

I have written a formula to flag runs in campaigns (ex: consecutive days above 19.) HOw can I create a formula that will then generate the production values specific for campaigns greater than 9 days? (Examples: campaign 1, 2, 3=>No value whereas campaigns showing 1,2,3,4,5,6,7,8,9 would show the appropriate number  19,20,21,22,23,24,25,26,27 etc.)

[#2]

I am not understanding exactly what you are looking for.  Could you please provide a sample data table with the values you expect to see?

[#3]

Perhaps this is a starting point, it checks, if the number of runs per campaign is greater or equal 9 days. However, it does not check whether days are consecutive, that's possible, but more complex. If that's needed, it would be really better if you could provide examples.

Key is the function "Col Number", see Scripting Index for details.