At first blush I see that that you have the following

=SUMPRODUCT(--(ISNUMBER(SEARCH(".2",YourStaticRange))))

=SUMPRODUCT(--(ISNUMBER(SEARCH(YourDynamicRange,".2"))))

You may want to switch things around in the equation with the dynamic range.

HTH,
Barb Reinhardt

"Graham" wrote:

HI
I have a Column (B) of 4 figure numbers to 2 decimal places. I want to
extract the frequency of each digit (0-9) in the First decimal place only.
Thanks to previous help I can get this to work over a fixed range e.g.
B39:B74, but as the column is added to on a daily basis, I would like to
calculate this over a dynamic range, indexed from the Row value in A2.
The following formula works ( for .2) over a static range :

=SUMPRODUCT(--(ISNUMBER(SEARCH(".2",$B$39:B74))))

but in trying to adapt it to a dynamic range, I simply get a value returned
of "0" ?

=SUMPRODUCT(--(ISNUMBER(SEARCH(OFFSET(B39,0,0,$A$2-ROW(B39)+1,1),".2"))))
Can anyone see where I'm going wrong ?
Many Thanks