functions

[KissFreak]

How do I tell row(like 1st & 2nd ones) to multiply and put total in the 3rd
row while at the same time at the bottom of the 1st & 3rd rows, by adding
these columns, put a total at the bottom of these columns?

Thanks
Mike

 

[Cutter]

Your question is pretty confusing so I'm guessing at what you want.

To multiply value in row 1 by value in row 2 and show product in ro
3:
(Assuming values are in Column A)
In A3 type: =A1*A2

The next part of your question is even more confusing. I don'
understand what you mean by "at the bottom of the 1st & 3rd rows, b
adding
these columns, put a total at the bottom of these columns".

If you're trying to add the results you get from multiplying Row
values by Row 2 values you put a SUM() formula in a cell and betwee
the brackets you put the range of cells where the values occur, namel
A3:whatever3