| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count items in range
Very nice, I'm working hard in order to understand it. Could you give me some
guide to it? Thanks, Stefi Teethless mama ezt *rta: Try this: None "Array" enter =SUM(COUNTIF(B6:K300,{"-100","=100"})*{1,-1}) "Steven" wrote: I have numbers in range B6:K300 and also some text. I want to count the number of occurances of cells with an absolute value of < 100. Thank you, Steven |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT to count items with duplicates where another column contains two defined items | Excel Worksheet Functions | |||
| Count unique items in range | Excel Worksheet Functions | |||
| Countif count items not in data range | Excel Discussion (Misc queries) | |||
| How do I count items within a date range in Excel? | Excel Worksheet Functions | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Threaded Mode
