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:$H5)))

Thanks for your help!