SUM until blank cell

  • Thread starter Thread starter JasonUT
  • Start date Start date
J

JasonUT

Hi,

I am trying to create a SUM function that will add SUM(X:Y) where X is
the Cell below the cell that contains the SUM solution and Y is the
cell above the first blank cell in the column. The X address is easy,
but the Y address always various depending on the days work.

I know this has got to be fairly straight forward, but I can't figure
it out.

Thanks,
Jason
 
=SUM(OFFSET(F1,0,0,ROW()-1))

would sum all numbers from F1 up to the cell in F where you enter th
formula.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum below until blanc 0
function returning SUM of 2 adjacent cols in 2 separate cells 7
COUNTIF - Summing non-numerical items in cells 5
Sumif based within non blank cells 3
use month in cell date to sum all relevant cells 2
Blank Check? 1
Blank Cells vs. Zero Values 2
sumif returns blank if all cells blank 7

Back
Top