I have two varialbles, I want to sum the second based on criteria from both.
So I want to count all the 1s in variable two if variable 1 is 2. I have a
couple formulas but none seem to work. This is what my data looks like
V1 v2
1 1
1 2
1 1
2 3
2 2
1 4
1
1

With your posted data in columns A and B,
this formula sums the Col_B items where
the corresponding Col_A item is 2:
=SUMIF(A2:A10,2,B2:B10)

Does that help?

Regards,

Ron Coderre
Microsoft MVP (Excel)

"mparker" wrote in message
...
I have two varialbles, I want to sum the second based on criteria from
both.
So I want to count all the 1s in variable two if variable 1 is 2. I have
a
couple formulas but none seem to work. This is what my data looks like
V1 v2
1 1
1 2
1 1
2 3
2 2
1 4
1
1

=SUMPRODUCT((C2:C9=2)*(D2:D9=1))
Regards,
Stefi

€žmparker€� ezt Ã*rta:

I have two varialbles, I want to sum the second based on criteria from both.
So I want to count all the 1s in variable two if variable 1 is 2. I have a
couple formulas but none seem to work. This is what my data looks like
V1 v2
1 1
1 2
1 1
2 3
2 2
1 4
1
1