How to get total filled column count in sheet1 to sheet2

[Sathish G]

Hi,

Some help me how to get total filled columns count from sheet1 to sheet2 excel formula

 

[Sathish G]

I just want data contained total columns counts from sheet1 to sheet2

 

[Muhammad_Usman]

You can used simple Counta function to count the number of non blank columns
Eg

=COUNTA(Sheet1!1:1)+COUNTA(Sheet2!1:1)

 

[Sathish G]

Thanks a lot! its working.

 

[Muhammad_Usman]

Thanks a lot! its working.

My Pleasure!