2 criteria display or sum?

  • Thread starter Thread starter ksnapp
  • Start date Start date
K

ksnapp

ok

here is the deal

I have a 2 columns with identifier number in them and a third colum
with actual numbers I want returnded. what I need is a function that
will return the number in the 3rd column if if the identifiers are the
same.

example

lets say column a is either 1 or 2 and column B is either 3 or 4 and
column C is just random numbers

A B C
1 3 9
2 4 6

I need a function that I will show me the contents of the c columns
cell that is in the same row as the A column that says 1 and the B
column that says 3.

here is what I have tried:

{=if(A:A=1,if(B:B=3, C:C))}

any help is greatly apprecieated
 
One way:

Enter the lookup value for column A in D1,
Enter the lookup value for column B in D2,

And try this :

=SUMPRODUCT((A1:A100=D1)*(B1:B100=D2)*C1:C100)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


ok

here is the deal

I have a 2 columns with identifier number in them and a third colum
with actual numbers I want returnded. what I need is a function that
will return the number in the 3rd column if if the identifiers are the
same.

example

lets say column a is either 1 or 2 and column B is either 3 or 4 and
column C is just random numbers

A B C
1 3 9
2 4 6

I need a function that I will show me the contents of the c columns
cell that is in the same row as the A column that says 1 and the B
column that says 3.

here is what I have tried:

{=if(A:A=1,if(B:B=3, C:C))}

any help is greatly apprecieated
 
Back
Top