When you say "bottom of each row", do you mean "bottom of each column"? If the cells have had the text typed ( as opposed to all cells containing formulae, some of which look blank ), then use the COUNTA function to count how many cells in a range are non-blank.