Multipling 2 columns
 

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

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

Multipling 2 columns
 

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

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

Multipling 2 columns
 

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

Multipling 2 columns
 

=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

Multipling 2 columns
 

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

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

Multipling 2 columns
 

ok...one more question...i need a formula to do the last column. I need to
do say whhich weeks the units are arriving but only if its material units
(25)
So i need a formula to ask if w1 25 units and w225 units and wk325 units
etc. then return a value that says the weeks and separate with a comma to
make easier to read...does that make sense?


Wk1 Wk2 Wk3 Wk4 Wk5 Weeks
style A 200 400 300 1,3,5
Style B 200 200 2,4
Style B 600 3


I have a table that tracks receipts by week...

December
Wk 1


"Teethless mama" wrote:

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

Multipling 2 columns
 

Assuming the col headers in B1:F1 are amended
to be just numbers, eg: "1" instead of "Wk1" (drop the "Wk")
you could then place this expression in G2:
=SUBSTITUTE(TRIM(IF(B225,B$1," ")&IF(C225,C$1," ")&IF(D225,D$1,"
")&IF(E225,E$1," ")&IF(F225,F$1," "))," ",",")
and copy G2 down to return exactly the results that you seek

Success? Celebrate it, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Tami" wrote:
...i need a formula to do the last column. I need to
do say which weeks the units are arriving but only if its material units
(25)
So i need a formula to ask if w1 25 units and w225 units and wk325 units
etc. then return a value that says the weeks and separate with a comma to
make easier to read...does that make sense?


Wk1 Wk2 Wk3 Wk4 Wk5 Weeks
style A 200 400 300 1,3,5
Style B 200 200 2,4
Style B 600 3