Thread
:
Multipling 2 columns
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
Posts: 3,718
Multipling 2 columns
=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 Quote
Teethless mama
View Public Profile
Find all posts by Teethless mama