I have two continually growing ranges.
I would like to establish how many times there is text in the same location
in each range - most of the values are 0.

I am guessing I need something like:

=sumproduct(--($AP$53:Offset($BG$53,0,0,$A$10),
ISTEXT),--($BH$53:Offset($BY$53,0,0,$A$10), ISTEXT))

naturally this won't work.

Sandy