Suming column problem

  • Thread starter Thread starter Greg15
  • Start date Start date
G

Greg15

This is a weird one. What I'm wanting to do is sum some data in
spreadsheet, but the number of rows I want to sum will change dependin
on info entered.

So my sum say starts at E4, and on this occasion I want it to sum dow
50 rows. The next time I may want it to sum down 100 rows. The numbe
of rows that need to be summed is calculated further up the worksheet
so somehow I need to set the formula up to always start adding at E
and then add down the number of rows based on a figured entered furthe
up the worksheet.

I hope this makes sense and is possible to do.

Thanks for your help:
 
One way

=SUM(OFFSET($E$4,,,$E$2))

where E2 would be the cell where you put the number rows you want to sum
you might want to guard against if the cell that determines the number of
rows
is blank

=IF($E$2="","",SUM(OFFSET($E$4,,,$E$2)))


--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Try: =SUM(OFFSET($E$4,,,E1))

where E1 contains the number of rows to be added, starting from E4
 
Back
Top