Sumproduct and ISTEXT?
Try this:
=SUMPRODUCT(--(ISTEXT($AP$53:OFFSET($BG$53,0,0,$A$10))),--(ISTEXT($BH$53:OFFSET($BY$53,0,0,$A$10))))
--
Biff
Microsoft Excel MVP
"Sandy" wrote in message
...
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
|