You're welcome, and thanks for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JBoyer" wrote in message
...
Thank you so much! Your formula is much simpler than mine and does the
same
trick. It is exactly what I was looking for. Sorry if my description was
vague, but I'm glad you were able to figure out what I wanted.

"Ragdyer" wrote:

Actually, this NON-array and NON-volatile formula should follow your
original concept, and still be able to be entered anywhere.

Again, set to start at Row 31:


=IF(COUNTA(INDEX(F:L,ROWS($1:2)*5+21,))=0,"",SUMIF (INDEX(F:L,ROWS($1:2)*5+21
,),"<0"))

--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"Ragdyer" wrote in message
...
If you can live with a zero return if the range is empty OR if there
are
no
negative values, try this formula, which can be entered *anywhere*,
and
copied down as needed:
It's set to start at Row 31,

=SUMIF(INDEX(F:L,ROWS($1:2)*5+21,),"<0")

If you want something similar to your original configuration, try
this,
which also can be entered anywhere and copied down as needed, after
the
CSE
entry:



=IF(COUNTA(INDEX(F:L,ROWS($1:2)*5+21,))=0,"",SUM(I F(INDEX(F:L,ROWS($1:2)*5+2
1,)<0,INDEX(F:L,ROWS($1:2)*5+21,))))

--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may
benefit !

--------------------------------------------------------------------------
-


"JBoyer" wrote in message
...



{=IF(ISBLANK(INDIRECT("F"&ROW()*5+21&":L"&ROW()*5+ 21)),"",SUM(IF(F31:L31<0,I
NDIRECT("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),F
ALSE)))}

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!