Hi All
I want to count the number of instances a number drops below zero.
However I want to be able to choose how many weeks the formula is calculating. For instance if I wanted to see all instances of a number dropping below zero I'd type 13 into an adjacent, to the formula, cell.
If I only wanted to see the number in this week I'd just type 1 into the cell, so it only looks at 1 column on data.
I am sure I did this before but I cannot find the formula I used. Please help
I want to count the number of instances a number drops below zero.
However I want to be able to choose how many weeks the formula is calculating. For instance if I wanted to see all instances of a number dropping below zero I'd type 13 into an adjacent, to the formula, cell.
If I only wanted to see the number in this week I'd just type 1 into the cell, so it only looks at 1 column on data.
I am sure I did this before but I cannot find the formula I used. Please help