ExcelBanter - SUM IF SUMPRODUCT

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - SUM IF SUMPRODUCT (https://www.excelbanter.com/excel-discussion-misc-queries/228309-sum-if-sumproduct.html)

mparker

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

Ron Coderre[_3_]

SUM IF SUMPRODUCT

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

Stefi

SUM IF SUMPRODUCT

=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

All times are GMT +1. The time now is 02:02 AM.