Returning desired number on conditions

Hello,

So say I have 3 columns:

I need to match the 3 digit code in the left most column, then if that matches, match another one digit code. Then if that matches, sum up the number/quantity of whatever situations meet those conditions. I'm sorry this is kind of confusing but any help would be greatly appreciated!

Thanks!

Rob

For Example heres a sample dataset

213 3 1,120
321 3 1,020
213 3 2,345
223 2 3,409
213 1 1,111

So for one i would like to match all of those that have the 213 code as well as the code "3", then sum up those two numbers to the right.... Thanks!

basically from the example i put in the original post. I want it to match the 213 and if that matches, match the 3, and if that matches sum up the numbers in the last column. So in this instance sum up 1,120 and 2,345. So I am looking for it to return the total of 3,455

Assuming your data is arranged in columns A:C (for simplicity's sake let's say A1:C100).

Place the number you'd like to check for column A (213) in cell D1 and the number for column B (3) in E1.

Your formula will be:

=SUMPRODUCT(--(A1:A100=D1),--(B1:B100=E1),(C1:C100))

Okay so here is part of the actual spreadsheet.

So I need to match the 3 digit code on the left (column A), then match a certain number in column E. And if those two specifications meet, sum up column P

Any ideas? the last one didn't work Ben, thanks tho

When you say "Match up", do you mean you want to choose one and get the total for it? Or have a list of all the combinations of column A and E with their totals?

Also, it looks like column P is just 0s and 1s - so you're not really looking for a total; you're just adding a third condition - that column P must equal 1.

Can you clarify please?

Sorry yeah I need the total of column p for all of those that match the first two criterias.

And Chemist it seems to be pulling put it keeps on returning 0, I need the sum of column p for those rows that meet the criteria.

Thanks again

Originally Posted by Montoro22

Sorry yeah I need the total of column p for all of those that match the first two criterias.

And Chemist it seems to be pulling put it keeps on returning 0, I need the sum of column p for those rows that meet the criteria.

Thanks again

What are the criteria? Can you post them please?

by criteria i mean match column a and then column e

And Chemist B it works good, I just have another question.

Is it possible to match say 2 numbers in column e, so for instance it will take both "2" and "B"?

Match column A and column E TO WHAT for god's sake? omg ... unless I'm really being dense here...

To each unque code in column A and to one of the 7 one digit codes in column E.... As I keep saying, I'm pulling all the data based on the 3 digit codes and the one digit code. If you look at the initial post you can clearly see.

So again, as I asked before, do you want a list of all the combinations of column A and E, with their respective totals?

---------- Post added at 02:09 PM ---------- Previous post was at 02:06 PM ----------

Originally Posted by Montoro22

by criteria i mean match column a and then column e

And Chemist B it works good, I just have another question.

Is it possible to match say 2 numbers in column e, so for instance it will take both "2" and "B"?

If you put the third condition in C16, for example, try

=SUMPRODUCT(--($A$1:$A$13=A16),(($E$1:$E$13=B16)+($E$1:$E$13=C16)),P1:P13)

Thanks ChemistB works perfectly, thanks for the help I appreciate it.

---------- Post added at 02:25 PM ---------- Previous post was at 02:23 PM ----------

Thanks Chemist works perfectly thanks for all the help! It's much appreciated