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!