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..

Basically,


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

where n = is the Row Number

Warm Regards
e4excel