How to Auto Sum with data of irregular rows of data?

I had wanted to do a sum some cost within a worksheet but with irregular rows.

The sum amount in the sample is I sum it myself. Is there any way to auto sum it after I paste the data into column A to G? The Original file was a template with A to G blank as I will need to copy data from different customers and the columns from H onwards are the data that I will need to find out from each customer.

There are already existing formula on L till X and where should I put the sum formula?

Hoped someone can help on this.

A million thanks.

Originally Posted by ChemistB

Okay, there may be an easier way depending on how the rows of data are getting there in the first place but ...
Entering this as an array (CNTRL SHFT ENTER instead of ENTER) in L11 and copying across and down to wherever you need it.
[FORMULA=SUM(INDEX(L$1:L10,MATCH(2,1/($L$1:$L10="FL"),1)+1):L10)[/FORMULA]See attachment.
Would that work for you?

Dear ChemistB,

Thanks for taking an effort to respond. As I had mentioned, from L to X, I already have an existing formula in it and the place there supposed to be blank, depending on how many rows of data I will paste into A to G.

Please paste the row data on the worksheet onto the checking worksheet and you will understand what I mean.

My apologies if I have not made myself clear. Therefore, I cannot stop on L10 and uses this formula on that particular row as the row to be sum will not be fixed. This is the part where I do not understand , where you had entered at the end of the formula, :L10, L17, L30, etc.

I had attached a corrected workbook for your reference.

Dear ChemistB,

Thanks for taking an effort with this "=IF(H8<>"",E8*$L$5,IF(H7<>"",SUM(L7:L$8),"")) " but it won't works.

I will need the formula to work when there are data between Column A, which reads "Do No" to the row with words "Total". I had made another sample for you to see.

In this worksheet "Checking", the rows that I will need to sum will be 11, 18 and 26 where these rows will not be fixed, depending on the data available.

In worksheet "Checking (2)", the rows that I need to sum will become 9, 16, 29 AND 37. The row to be sum will not be consistant.

Originally Posted by bebo021999

Get it by conditional formating:
Menu Home/Conditional Formating/New Rule/Use a formula.../Format values where this formula is true: =A8="Total", choose the format for border. Anyway, I could not find the double line format, just single.

Dear bebo021999, thanks alot. I also cannot find the double bottom line in the conditional formatting. But I think it's already good enough.

Thank you!!