Count Words in Range
=SUMPRODUCT(LEN(A1:A5)-LEN(SUBSTITUTE(A1:A5," ","")))+COUNTA(A1:A5)
© Copyright 2004 - 2010,
andrewsexceltips.net
All Rights Reserved.