| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
count the # of consecutive negative #'s in a range
hello, I was wondering if there is a worksheet function that will do this. e.g. i have a range with some #s like so... -8 9 7 -8 -9 6 4 8 -8 -9 -2 -3 5 -8 -9 6 what i want is to count the consecutive # of negative #'s in this list. for the example above the answer will be 4 (-8 -9 -2 -3) is this possible or do i have to write a macro for this? -- newToExcel ------------------------------------------------------------------------ newToExcel's Profile: http://www.excelforum.com/member.php...o&userid=27192 View this thread: http://www.excelforum.com/showthread...hreadid=484569 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Describe high/low range with CountIf (ex. count if >90 and <100 | Excel Worksheet Functions | |||
| Count formula within a named range. | Excel Discussion (Misc queries) | |||
| Ploting data with a large range including negative numbers | Charts and Charting in Excel | |||
| Count Consecutive Numbers in a Row | Excel Worksheet Functions | |||
| I have a list of dates that I need to count based on a date range | Excel Worksheet Functions | |||
Threaded Mode
