By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

Get count of column A in another sheet

The sheet name is in column A.

Get the count of items in Column A in the sheet name in active sheet's column A

A1 = "PTO - XYZ data"

A1 contains the sheet name

=indirect("counta('" & A1 & "'!A:A)")