=COUNTA(range of cells)-COUNT(range of cells)


Gord Dibben MS Excel MVP


On Thu, 20 May 2010 09:41:01 -0700, Malcolm
wrote:

Is it possible to autosum the total of cells that contain only text, in a
worksheet that contains cells with only text and cells with only numbers?