| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count of item in excel workshop
if you want the number of cells that contain the single letter R
=Countif(A5:L31,"R") if you want the number that contain an R =Countif(A5:L31,"*R*") This is not case sensitive. -- Regards, Tom Ogilvy "Chris" wrote in message ... Hello all, Is there a way to count the amount of a specific item "ie. R" in XL2000. I am presently playing with the =COUNTA (A5:L31) or =COUNT(A5:L31) functions to no avail any help is greatly appreciated cheers Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Item numbers result in item description in next field in Excel | Excel Worksheet Functions | |||
| Excel and MS HTML HELP Workshop | Excel Discussion (Misc queries) | |||
| No more new fonts may be applied in this workshop. | New Users to Excel | |||
| how to count specific item??? | Excel Discussion (Misc queries) | |||
| to How to use Excel formula to count the item | Excel Discussion (Misc queries) | |||
Linear Mode
