Help with formula

[Quimera]

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

 

[Pete_UK]

Put a dollar symbol, $, in front of the 195 to fix it:

=B2*B$195+C2*C$195+D2*D$195...

would become:

=B3*B$195+C3*C$195+D3*D$195...

when copied down. You do not need the SUM function.

Hope this helps.

Pete

 

[Quimera]

Hi Pete,

Yes, it certainly did help. How could I have NOT know that? Duh!

Many thanks,
Joan