Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with formula
Hi , I need some help
I have a formula as follows: =IF(AND(M14="",ISNUMBER(M15)),SUM(OFFSET(M15,0,0,M ATCH(TRUE,M15:M38="",0)-1)),"") The formula does not work if there is a ( $ ) in cell M14 Is there a way to chance the formula so that it will work with the ( $ ) in cell M14 eg: M row 14 $ row 15 25 row 16 18 row 17 17 row 18 28 any help please -- bill gras |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |