| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count it
How all i have two problems im hoping you can help me solve Firstly i have a list of numbers and i want to count all the entries that are less than -0.1 and higher then 0.1 Secondly I want to sum the umbers that are over 0.1 and less than -0.1 example (as this one's a bit more complicated) 0.13 (0.03 over) 0.05 (in target) -0.25 (0.15 over) -0.08 (in target) sum 0.18 All the help you guys give is always much appreciated, ceemo -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=510717 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Threaded Mode
