| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help to adapt Formula syntax to work with Visible Filtered Cells
Hi All,
I previously received assistance from Domenic with the great working Formula below BUT can the Formula below be adapted to return the results of Filtered Visible Cells? =SUM(N(OFFSET(A1,LARGE(IF(Cost<"",ROW(Cost)),{1,2 ,3,4,5})-ROW(INDEX(Cost,1)), 0))) ....confirmed with CONTROL+SHIFT+ENTER. The above Formula Sums the LAST 5 numeric values in a single column Dynamic named Range - "Cost" . The column also contains valid zero’s and invalid blanks (empty cells). In Define Name Refers To box "Cost" defined as... =Stock!$R$71:INDEX(Stock!$R$71:$R$65536,MATCH(9.99 999999999999E+307,Stock !$R$71:$R$65536)) Assistance most appreciated. Link to previous Thread: http://www.officekb.com/Uwe/Forum.as...OfficeKB. com Thanks Sam -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200509/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My formula won't work | Excel Worksheet Functions | |||
| Formula syntax {;;;} | Excel Worksheet Functions | |||
| Trouble with Syntax - IF formula | New Users to Excel | |||
| Formula syntax error - chinese and gibberish | Excel Discussion (Misc queries) | |||
| Syntax For Conditional Formula | Excel Worksheet Functions | |||
Threaded Mode
