See at a glance that how many days rates were positively increased in last 10 days.

[roshanakhtar]

Please help and suggest a formula. Excel sheet is enclosed. In column B rate of commodity is posted daily through a macro. Column C calculates percentage increase or decrease. I want to see at a glance that how many days rates were positively increased in last 10 days by counting positive numbers in column C. Rates will be posted daily hence change in cell reference in formula used by me will occur daily that is cumbersome. Please suggest modified formula.

[Punnam]

Hi,

Find the updated file

Punnam

[samba_ravi]

=COUNTIF(OFFSET($C$1,COUNT($B:$B)-9,0,9,1),">"&0)
Try this formula

[roshanakhtar]

Thanks nflsales,
This formula worked fine as I required. Thank you very much again. Thanks Punnam for suggesting updated formula, though I used nflsales formula as it is as per my requirement. Thanks again Punnam for taking pain in solving my problem. Thanks again both to you.

[Punnam]

@ nflsale
Could u explain in detail the offset function .
Punnam

[samba_ravi]

Sorry Mr Punnam i am very poor in communication try to under stand
Go for Help in Excel with Offset Function.
or

Stay in the cell in which we have formula and Click on Formulas Button on tools menu then click on Evaluate formula, here you can see how the formula is working

[Punnam]

Thanks for the response
I have used the evaluation TAB but unable to trace the logic .
I will try to find it .

Punnam