Would appreciate help with formula or function

[e_a_g_l_e_p_i]

I have a worksheet that has in column "D" a quanity, a different quanity in each row of column "D"

In column "E" I have a dollar amount in each roll




the number of the rows in each column is, starts ar 2 and ends at 626

What I would like to do is use a formula or function that will give me a total of what each row would equal and then a total for the sum of all rows.

[macropod]

Hi eaglepi,

Suppose you want to find the quantity * price for the item in D2, where it's unit price is in E2. The formula in, say F2, would be:
=D2*E2
You can input that forumula then simply copy it down to row 626. To get the sum of all items in column F, you could use a formula like:
=SUM(F:F)
in any other column, or:
=SUM(F2:F626)
in, say, F1, F627, or any other cell not in the F2:F626 range.