Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
{=IF(ISBLANK(INDIRECT("F"&ROW()*5+21&":L"&ROW()*5+ 21)),"",SUM(IF(F31:L31<0,INDIRECT("F"&ROW()*5+21&" :L"&ROW()*5+21),FALSE)))}
{=IF(ISBLANK(INDIRECT("F"&ROW()*5+21&":L"&ROW()*5+ 21)),"",SUM(IF((INDIRECT("F"&ROW()*5+21&":L"&ROW() *5+21))<0,INDIRECT("F"&ROW()*5+21&":L"&ROW()*5+21) ,FALSE)))} The first formula works but it is not really what I want to do, when I change it to the second formula which is what I want it to do it gives me a #VALUE! ERROR. This is the only part that changes: F31:L31<0 changes to (INDIRECT("F"&ROW()*5+21&":L"&ROW()*5+21))<0 Hope someone can give me a solution to fix this problem! Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula not working | Excel Worksheet Functions | |||
IF Formula not working | Excel Discussion (Misc queries) | |||
SUM formula not working | Excel Discussion (Misc queries) | |||
Formula not working | Excel Worksheet Functions | |||
Why isn't this formula working? | Excel Discussion (Misc queries) |