Dear Forum,

Basically, if it were possible to iterate the functionality 7 times for a Single Data Range and also save the count then we will get the answers for the requirement..

PHP Code: 
=SUMPRODUCT(--(An:Cn<>"")) and this has to be iterated 7 Times

where n = is the Row Number 
I am not a pro at all but have seen some codes where using the ROW INDIRECT combination its made to create an array for the entire Range..

So , is something possible in this type of approach or I am just expecting the impossible..

Warm Regards
e4excel