Thread: calculation
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hong hong is offline
external usenet poster
 
Posts: 23
Default 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!