Microsoft Excel Hints and Tips
Is there a way to count the number of words within a range ?
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.
Back to Questions Index
Return to Excel Exchange homepage.