Find last non-blank value in column, multiply by value in same row, diff column

I have several monthly reports where data is imported form another file, and therefore the values in the data range changes each month, as well as the location and number of non-blank cells. The range is always numeric, values are always in ascending order down the column (though there are typically multiple values that are the same in its respective column), but the location of the last non-blank cell changes with each new month's data set.

I haven't found a solution that does what I'm trying to do, which is:

Find the last non-blank cell in a column, take the value of that last non-blank cell and multiply it to a static number that is in the same row, but a different column to the right.

In the example, the "totals" column is irrelevant. I'm attempting to make a new row at the bottom that returns the value of the last non-blank cell in its respective column multiplied by the static multiplier (column N) that is in that non-blank cell's row.

Any help is greatly appreciated!


Excel Example 1.jpg

These are real blank cells, no formulas, spaces, etc.

Thanks for info on the file attachment....This is my first post.

I appreciate the input so far, though it isn't really getting me where I'm trying to be. I may not be explaining it correctly.

I'm looking to write a formula that will search (for example) cells A2:A14, find the value in the last cell with data, then depending on what cell location that is (lets say it is A12), multiply the value in A12 by the number in the same row (row 12) but another column (column N).

I'm looking for this because each month the last cell with data in any particular column can change and I always want to multiply the value in the last data cell with a number in the same row, just a different column.

It's a little tough I'm thinking. Thanks!

Great, that was exactly what I needed. Thanks for all the help!