{=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!

Perhaps better to describe what you want the formula to do....

Assuming that you have this formula first in C2 and that it should sum the
negative values in F31:L31...then C3 should sum negative values in
F36:L36.....etc.

Try this formula for C2 copied down

=SUMIF(OFFSET(F$26:L$26,ROWS(C$2:C2)*5,0),"<0")



"JBoyer" wrote:

{=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!