Count the text in a column - Part II
 

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!

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)


"Peter Curtis" wrote in message
...
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!

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


On Thu, 6 Jan 2005 05:49:04 -0800, Peter Curtis
wrote:

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!

Why not post a 5-row sample along with expected result?

Peter Curtis wrote:
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!