Multipling 2 columns
You're Welccome!
"Tami" wrote:
Amazing...that worked perfectly.
thx.
"Teethless mama" wrote:
=SUMPRODUCT(--(C2:C4=412),A2:A4*B2:B4)
"Tami" wrote:
ok, now i have another question...assume i want to do that sumproduct but
only IF the class is 412...so the answer would be $70...
units ticket class
2 20.00 412
4 10.00 488
3 10.00 412
"Teethless mama" wrote:
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
|