Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

It is not clear why "finding a specific line in a column H" is important, however it is easy enough to conditionally sum a range. Place this formula in cell I1 and copy down:

=IF(H1>0,SUM(C1:G1),"N/A")

Adjust the "N/A" entry to suit i.e., make it zero or a null string if desired.