Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count of item in excel workshop
The only function that may work for you is the COUNTIF(<Range,<Criteria)
function to count the number of occurences that meets the criteria or the SUMIF(<Criteria Range,<Criteria,[<Sum Range]) function to sum up the total of the values based on the criteria that has been met. Note: <Criteria Range is just the range that the <Criteria argument is ran against, though if <Sum Range is left out, then what's in <Criteria Range gets summed up for those values that met criteria. -- Ronald R. Dodge, Jr. Production Statistician Master MOUS 2000 "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 | |||
to How to use Excel formula to count the item | Excel Discussion (Misc queries) | |||
count of item in excel workshop | Excel Programming |