i am working in excell 2003 and have little hair left.

Any help will be appreciated. I will even be glad to mail this spreadsheet
to someone so that they can see exactly what i am doing.

here goes

If the number 1 is is in a cell within the column range of D3 to D32, then
add the number in the corresponding row cell Hx (where X equals the row
number), to the total at cell H34 and cntinue to the next row.

example

If the cell D3=1, then add the number in the cell H3 to thee the running
total in H34 and record the new Number in H34.

next row

If thte cell D4=1,Then add the number in the cell H4 to the running total
that was written to H34, and record the new number in H34

continue to the end. H32


I have to be able to insert more rows between row 3 and 32 so that more
information can be replicated there. adding rows would change the running
total cell respectivly.

The reason for this spreadsheet is to keep track of the number of newspapers
given to clients and picked up from clients on a daily basis. hence wanting
to add more rows as clients are added with a calculation to split them to
racks, stores,delivery venders, ect while keeping running totals as the
spreadsheet sees various types of deliverys.

if a 1 is not in the trigger cell ( example D3) then nothing happens to
that formula

Thanks in advance for any help.

Frank Freeman
707-557-4066