| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to code it in excel?
=SUM(INDIRECT("C"&SMALL(IF($A$1:$A$1000="",ROW($A$ 1:$A$1000)),ROW()-1)):INDIRECT("C"&SMALL(IF($A$1:$A$1000="",ROW($A$1 :$A$1000)),ROW())))
put in a free cell in row 2 << then CTRL+SHIFT+ENTER then copy down |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
| Text formatting | Excel Worksheet Functions | |||
| Using Access in Excel VB Code | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| VB Code and Excel | Excel Worksheet Functions | |||
Hybrid Mode
