View Single Post
  #2  
Old March 29th, 2010, 12:57 PM posted to microsoft.public.excel.newusers
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default sum of cells containing text

EXCEL 2007

=+COUNTA(M1:M20)

- the above will count non blank cells for the specified range.

If my comments have helped please hit Yes.

Thanks.

"charlotte" wrote:

I have a selection of cells and i need the sum if they contain text anyone no
if this is possible?