Count the text in a column - Part II

Gord Dibben

Posts: n/a

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I count the amount of text in a column and then add them	Peter Curtis	Excel Discussion (Misc queries)	1	January 6th 05 01:06 PM
text from one column into multiple columns	Jeff Brown	Excel Discussion (Misc queries)	6	December 22nd 04 10:07 PM
Count text	Shannon	Excel Discussion (Misc queries)	1	December 18th 04 03:59 PM
Putting text in a column based on variable text from another colum	Jacky D.	Excel Discussion (Misc queries)	1	December 16th 04 06:09 PM
Is there a way I can enter a letter to proceed text a column of ce	Gordon	Excel Discussion (Misc queries)	3	December 13th 04 07:13 PM

All times are GMT +1. The time now is 04:33 PM.

Menu

About Us