The answer to this is most likely extremely simple, for which I
apologize.

I have 10 columns, each representing an inventory item.

Each row represents a name and the qty ordered per item .  The number of
names rarely changes.

A single row at the bottom of each inventory column contains the price
of the inventory item.

I want to add a Column at the end of each line which calculates the
total valueof their order.

=SUM(B2*B195)+C2*C195+D2*D195...)
=SUM(B3*B195)+C3*C195+D3*D195...)
etc.

However, when I copy the formula it does not retain the row number "195"
containing the price.

What is the syntax to indicate the row number is a constant?

Thanks for your help
Joan