__Microsoft Excel Hints and Tips__

__Question__

Is there a way to count the number of words within a range ?

__Solution__

Type the following formula **=SUM(LEN(TRIM(A1:C3))-LEN(SUBSTITUTE(A1:C3,"
",""))+1)-SUM(IF(ISBLANK(A1:C3)=TRUE,1,0))** -
assuming that you want to count the number of words within the range of cells
A1:C3.

After you have entered this formula you must select the cell that has the formula and then press F2 and then Ctrl + Shift + Enter to make this an Array Formula.

Return to Excel Exchange homepage.