Count the text in a column - Part II

P

Peter Curtis

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

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

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
 
Top