calculation
 

Hello everyone,

I have the price on col.A, and quantity on Col.B

I need to get the sum for price*quantity.

What function I should use?

Thank you!

calculation
 

In C1, type "=A1*B1".
--
CFS


"Hong" wrote:

Hello everyone,

I have the price on col.A, and quantity on Col.B

I need to get the sum for price*quantity.

What function I should use?

Thank you!

calculation
 

have you tried =a*b i.e a1=1.25 b1=2 then in c1 enter =a1*b1 answer
should be 2.50
"Hong" wrote in message
...
Hello everyone,

I have the price on col.A, and quantity on Col.B

I need to get the sum for price*quantity.

What function I should use?

Thank you!

calculation
 

Not like that, I forgot.

There is a function, you can't make it automatic calculate col.A*col.B and
sum total.

I just forgot.

"CFS" wrote:

In C1, type "=A1*B1".
--
CFS


"Hong" wrote:

Hello everyone,

I have the price on col.A, and quantity on Col.B

I need to get the sum for price*quantity.

What function I should use?

Thank you!

calculation
 

I remember now,
It's sumproduct function

Thank you!

"Meebers" wrote:

have you tried =a*b i.e a1=1.25 b1=2 then in c1 enter =a1*b1 answer
should be 2.50
"Hong" wrote in message
...
Hello everyone,

I have the price on col.A, and quantity on Col.B

I need to get the sum for price*quantity.

What function I should use?

Thank you!