Hi,
Please can someone help me?
My range is C7:C737 and I have a value of 10 in cell C5.
What I would like is to be able to continually count if the values in the range that are greater than the value in C5 but if one value is less or equal then the count goes back to 0.
Also there will be blank cells in the range that will need to be ignored.
Any help would be appreciated.
Thanks
Dan
Please can someone help me?
My range is C7:C737 and I have a value of 10 in cell C5.
What I would like is to be able to continually count if the values in the range that are greater than the value in C5 but if one value is less or equal then the count goes back to 0.
Also there will be blank cells in the range that will need to be ignored.
Any help would be appreciated.
Thanks
Dan