Posted to microsoft.public.excel.worksheet.functions

Byron720

external usenet poster

Posts: 61

Counting comments

I have a report where one of the columns is "Comments". Let say one of them
says : This part is unavailable. The report is really big and so are the
range of comments. What I need is a formula that calculates for example how
many of the comments have the word unavailable. I tried VLOOKUP, IF, COUNTIF,
but they don't seem to work (as far as I know). Please help

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
comments	Louise	Excel Discussion (Misc queries)	0	September 23rd 06 12:52 AM
counting comments	Robert Shlemkevich	Excel Worksheet Functions	2	September 15th 05 08:26 PM
Counting rows, then counting values.	Michael via OfficeKB.com	Excel Discussion (Misc queries)	7	August 4th 05 10:57 PM
Counting names in a column but counting duplicate names once	TBoe	Excel Discussion (Misc queries)	9	May 11th 05 11:24 PM

All times are GMT +1. The time now is 09:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us