Thread: Multipling 2 columns
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Multipling 2 columns
You're Welcome!

"Tami" wrote:

Thank you!!!!!!!!!!!!!!!!!!!!!!!!!!
Have a great day!

"Teethless mama" wrote:

=SUMPRODUCT(B2:B4,C2:C4)


"Tami" wrote:

hi.
How can i multiply two columns and put result in one cell?In the example
below i would want $110 to appear in cell A1
example

units ticket
2 20.00
4 10.00
3 10.00

Reply With QuoteReply With Quote