Hello,

I have created a 2 formulas that I know work, but was wondering whether
anyone could suggest a simpler one that could do the job for both.
Formula 2 is based upon the answer from Formula 1. The answer from
Formula 2 is the one I want to keep.

column F contains text values including the value "N*"
row 5 contains the first entry in the list
Cell H5 contains the 1st formula: IF((F5="N*"),(1),"")
Cell I5 contains the 2nd formula:
=IF(((SUM(H$4:$H5))=(SUM(H$4:$H4))),"",(SUM(H$4:$H 5)))

Thanks for your help!


--
m.cain
------------------------------------------------------------------------
m.cain's Profile: http://www.excelforum.com/member.php...o&userid=32773
View this thread: http://www.excelforum.com/showthread...hreadid=526044