Hi - This might go into a Guru's only forum and you can change it if needed.

I just did this problem that is much too long. I used Countif with Rows(), Columns(), Indirect() and Address()...

There must be a simpler formula!! I think a fixed array of {1,2,3,4,5,6,7,8} using choose or sum(If(countif(..),1,0)).

I just never know when to use Array formulas or Sumproduct or ???

See my "Way too hard answer" at the end of
http://www.excelforum.com/excel-form...-is-mixed.html