Sum / Count total from specific cell until this cell

[jamewoong]

I am importing data starting from row 7 to below (above is header that will freeze). I would like to add a formulas at the end of the a cell which will sum up everything from cell 7 (F7) until this cell -2 (the cell with the formulas minus two since there will be a space before it).

Would like to have a formula that will sum up the total and another formula that will count the total of item.

Appreciate if someone know how.

It is like clicking on the F7, then Ctrl + Shift + Down >>> Sum of thisUntitled.pngCountReport4.xlsx

[Kaper]

Elegant way would be by using macro-enabled workbook and worksheet change event handler (you can find number of examples on this forum). But easy way if you do not expect too many rows of data woukd be in F17 formula:

Please Login or Register  to view this content.

in E17:

Please Login or Register  to view this content.

copy this one to A17 and in B17:

Please Login or Register  to view this content.

now copy A17:F17 several rows down and as you add another data the total row will be accurate and located after one empty row.