# Summing with multiple conditions

#### kaldag

##### New Member
In column A is a discription. In column B is a value. What I want to do is sum the values in column B if the discriptions in column A match as many as two or three discriptions. I have tried a SUM array formula with no results. HELP

Ken

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
On 2002-09-06 13:39, kaldag wrote:
In column A is a discription. In column B is a value. What I want to do is sum the values in column B if the discriptions in column A match as many as two or three discriptions. I have tried a SUM array formula with no results. HELP

Ken

Give a small sample along with the expected result.

column A Column B

Mon 25
Tues 47
Wed 7412
Tues 45
Mon 58
Wed 47
Wed 45
Mon 47
Tues 45
Wed 4185

What I need is to sum all the values from column B that have Mon and Tues as disc from Column A.

Ken

On 2002-09-06 14:01, kaldag wrote:
column A Column B

Mon 25
Tues 47
Wed 7412
Tues 45
Mon 58
Wed 47
Wed 45
Mon 47
Tues 45
Wed 4185

What I need is to sum all the values from column B that have Mon and Tues as disc from Column A.

Ken

=SUMPRODUCT((A1:A10=D1:E1)*(B1:B10))

where D1 houses Mon and E1 Tues, which I assume to be entered as text.

I have a table with three columns, Customer#, Part # and QTY. I would like to return the Qty value associated with that part# and cust#. The problem is the customer# can be listed several times along with the same part# with differet qty's.
Example:
cust prt# qty
x 123 1
x 123 3
x 456 1
y 123 3
z 123 5
z 123 2

I was using a vlookup for cust# then another lookup for prt# but how do I add & get the sum of the same prt#? x 123 4, z 123 7

Maybe there is an easier way. Thanks for the help.

On 2002-09-08 08:28, grev wrote:
I have a table with three columns, Customer#, Part # and QTY. I would like to return the Qty value associated with that part# and cust#. The problem is the customer# can be listed several times along with the same part# with differet qty's.
Example:
cust prt# qty
x 123 1
x 123 3
x 456 1
y 123 3
z 123 5
z 123 2

I was using a vlookup for cust# then another lookup for prt# but how do I add & get the sum of the same prt#? x 123 4, z 123 7

Maybe there is an easier way. Thanks for the help.

Let A2:A7 houses cust values, B2:B7 prt#'s, and C2:C7 qty values.

=SUMPRODUCT((\$A\$2:\$A\$7=E1)*(\$B\$2:\$B\$7=F1),\$C\$2:\$C\$7)

where E1 houses a condition like "x", a cust value and F1 123, a prt#.

thanks for your help it worked great! Have one more question though. How can I return a value where it is in the same column as the cust#. For example:
cust #
x (has values under the same column such as)
a
g
j
How can I retrieve the value j

On 2002-09-08 10:42, grev wrote:
thanks for your help it worked great! Have one more question though. How can I return a value where it is in the same column as the cust#. For example:
cust #
x (has values under the same column such as)
a
g
j
How can I retrieve the value j

I don't think I understand the question. What is the retrieval cue...I mean key for picking out "j" -- "j" itself or what?

Replies
4
Views
381
Replies
3
Views
140
Replies
3
Views
339
Replies
1
Views
128
Replies
5
Views
105

1,217,763
Messages
6,138,459
Members
450,139
Latest member
myexcel202424

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back