How can I keep the formula the same for an entire column?

[jacatsos]

I'm inserting new information at the top of my worksheet. Unfortunately the formula for what WAS row one: =SUMIF(TotalSales!$B:$B,A1,TotalSales!$H:$H) Will no longer work for row one because as more date is collected row 1 shifts down to row 2. Row two still looks good but there is no longer a formula for the new rows inserted.

To be clearer... I would like to have the following:
=SUMIF(TotalSales!$B:$B,A1,TotalSales!$H:$H) in cell B1
=SUMIF(TotalSales!$B:$B,A2,TotalSales!$H:$H) in cell B2
=SUMIF(TotalSales!$B:$B,A3,TotalSales!$H:$H) in cell B3

How can I keep that formula in row one as I keep inserting new rows?

Thanks for any help you can offer

 

[kevatarvind]

I'm inserting new information at the top of my worksheet. Unfortunately the formula for what WAS row one: =SUMIF(TotalSales!$B:$B,A1,TotalSales!$H:$H) Will no longer work for row one because as more date is collected row 1 shifts down to row 2. Row two still looks good but there is no longer a formula for the new rows inserted.

To be clearer... I would like to have the following:
=SUMIF(TotalSales!$B:$B,A1,TotalSales!$H:$H) in cell B1
=SUMIF(TotalSales!$B:$B,A2,TotalSales!$H:$H) in cell B2
=SUMIF(TotalSales!$B:$B,A3,TotalSales!$H:$H) in cell B3

How can I keep that formula in row one as I keep inserting new rows?

Thanks for any help you can offer

=SUMIF(TotalSales!$B:$B,A$1,TotalSales!$H:$H) in cell B1

 

[jacatsos]

Thanks for the reply. I entered the formula you suggested but all rows (inserted above what was row 1) still have no formula so I still have to add them in one by one. There must be a way to keep that formula at the top but I don't know what it could be.

Thanks for trying.