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!