On second test, your formula does work. Interesting solution!

Thank you!


"Robert Crandal" wrote in message
...
That works for ONE row. My sheet has 60 rows and 9 columns.
Is this forumula missing something?


"plinius" wrote in message
...


=SUMPRODUCT(--(SUBTOTAL(3,OFFSET(A1:I1,ROW(1:60)-1,))0))

Is this enough FAST?
E.