G Guest Jan 6, 2005 #1 I would like to count the text in a column then for it to add a figure in another cell if it meets the text criteria Thanks!
I would like to count the text in a column then for it to add a figure in another cell if it meets the text criteria Thanks!
B Bob Phillips Jan 6, 2005 #2 Do you mean count the characters? If so =SUM(NOT(ISNUMBER(A1:A20))*LEN(A1:A20)) as an array formula (committed with Ctrl-Shift-Enter) -- HTH RP (remove nothere from the email address if mailing direct)
Do you mean count the characters? If so =SUM(NOT(ISNUMBER(A1:A20))*LEN(A1:A20)) as an array formula (committed with Ctrl-Shift-Enter) -- HTH RP (remove nothere from the email address if mailing direct)
G Gord Dibben Jan 6, 2005 #3 Peter Your description is not too clear in this post or the first post. Perhaps =SUMIF(A1:A33,"Monday",B1:B33) Which will sum up cells' data in column B that match Monday in Column A Gord Dibben Excel MVP
Peter Your description is not too clear in this post or the first post. Perhaps =SUMIF(A1:A33,"Monday",B1:B33) Which will sum up cells' data in column B that match Monday in Column A Gord Dibben Excel MVP
