Referencing column in another sheet from row 2 only

kat_h

I am trying to set up a formula that counts the number of cells containing information in the first column on another sheet. I just don't want it to count the text that is in row 1 (ie I just want it to count from row 2 onwards as I am constantly adding data to column). I don't want the formula to even reference row 1 as it creates a "hover" box that hides other data when viewing the referenced sheet on a display screen.

I have tried just selecting the cells in the column that I want but as data is added to sheet or shifted to other sheets, it is constantly reducing the range that has been selected for the formula requiring constant updating of the formula range.

Andrée Starå

Hi Kat,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Barry Bowles

Hi Kat - try this formula =COUNT({Column1}) - 1

You know you don't want ROW1 counted in the total so just deduct 1 from the total column count.