Count formula

[kiran s]

Hi,

Stuck with a count formula challenge, pls assist
1) Count values in a row >0,
2) 1st Row to be looked into

Sat Sun Mon Tue Wed
26-Sep 27-Sep 28-Sep 29-Sep 30-Sep Mon Tue Wed Thu Fri Sat Sun
2 1 1 1 1 0 0 0 0 0 0 0
1 1 2 1 1
1 1 1 1 1
1 1 1 1 1


Regds

 

[Khalid NGO]

Hi Kiran,

It is difficult to guess how your data is looks like, can you post a sample file with expected output?

Regards,