View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mparker mparker is offline
external usenet poster
 
Posts: 7
Default SUM IF SUMPRODUCT

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