Hi all,
I am having a problem with a double counting sumif, because of and array.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 232px"><col width="100"><col width="100"></colgroup><tbody>
</tbody>
I want to count up all the numbers of the expertises Banking / Juridisch /Communicatie. I created the following formula:
=ArrayFormula(SUM(SUM.If(A2:A4;{"*Banking*";"*Communicatie*";"*Juridisch*"};C2:C4)))
But it double counts the first row. Is it possible to only count a row once? The outcome in this case was 649, instead of the intended 427.
Hope someone knows a way of doing this! Looking forward to hearing any solutions.
I am having a problem with a double counting sumif, because of and array.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Expertises | OB | Total Events |
Banking / Finance, PR / Communicatie, HRM / Recruitment, IT / ICT, Management, Marketing / Product Management, Sales | OB | 222 |
Juridisch | OB | 205 |
IT / ICT, Marketing / Product Management, Sales | OB | 187 |
<colgroup><col style="width: 232px"><col width="100"><col width="100"></colgroup><tbody>
</tbody>
I want to count up all the numbers of the expertises Banking / Juridisch /Communicatie. I created the following formula:
=ArrayFormula(SUM(SUM.If(A2:A4;{"*Banking*";"*Communicatie*";"*Juridisch*"};C2:C4)))
But it double counts the first row. Is it possible to only count a row once? The outcome in this case was 649, instead of the intended 427.
Hope someone knows a way of doing this! Looking forward to hearing any solutions.