I have a worksheet with 3 columns of cells, each cell with a name and address
in it. Down the left hand side there are area categories, like London or
Leeds.
I want to have a total at the bottom that displays the number of cells for
each area.
For example, it says Leeds on the left, then there are two names in column
a, 1 in column b, and three in column c.
I need a formula that I can put in a cell below this that will total the
cells and display 6.

anyone know if this is possible?