Maybe something like this:

With
Numeric values in the columns B:K, beginning in Row_2
and some rows skipped

A2: =SUM(B2:K2)
A3: =SUM(B3:K3)+LOOKUP(10^99,$A$1:OFFSET(A3,-1,0))

The formula in A3 can be copied anywhere down Col_A, skipping rows if needed.
It will continue to calculate the cumulative total.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Bonitae" wrote:

I have an Excel spreadsheet with numbers that I want to sum in a row, carry a
cummulative sum in a column, and be able to skip a few rows and still carry
the cummulative number by picking up the same formula. However, once I skip a
few rows with no information, Excel wants to only add the row and not carry
forward the previous sum. Clear as mud?? Can you help?
--
Bae