how to count non blank cells from another worksheet
 

I have multiple worksheets.
I need to count non blank cells of column A of sheet 2
to a cell in sheet1.
I tried using CountA formula but it dint work.
Please help as i am new to Excel.

how to count non blank cells from another worksheet
 

Hi,

isn't it working with =COUNTA(Sheet2!A:A)?

"Anne" wrote:

I have multiple worksheets.
I need to count non blank cells of column A of sheet 2
to a cell in sheet1.
I tried using CountA formula but it dint work.
Please help as i am new to Excel.