would like the top cell to automatically tell me how many cells below it have text.
V V L Apr 2, 2012 #1 would like the top cell to automatically tell me how many cells below it have text.
T trip_to_tokyo Apr 2, 2012 #2 would like the top cell to automatically tell me how many cells below it have text. Click to expand... EXCEL 2007 =COUNTA - will count the number of cells in a range that are not empty.
would like the top cell to automatically tell me how many cells below it have text. Click to expand... EXCEL 2007 =COUNTA - will count the number of cells in a range that are not empty.
H hiddenpunch Apr 2, 2012 #3 would like the top cell to automatically tell me how many cells below it have text. Click to expand... thanks!
would like the top cell to automatically tell me how many cells below it have text. Click to expand... thanks!
C Cimjet Apr 3, 2012 #4 Hi Not sure if i understand but try this : =counta(A3:A200) Adjust the range to your needs. Cimjet
