Hi There
Im looking to do a sumif on the below data where I sum the values that correspond to a particular region, whether its billable or unbillable and it relates to either Q1 or Q2.
Is this possible with sumifs? Will this require an array formula?
[TABLE="width: 455"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Region[/TD]
[TD]Billable / Non Billable[/TD]
[TD]Q1[/TD]
[TD]Q1[/TD]
[TD]Q1[/TD]
[TD]Q1[/TD]
[TD]Q2[/TD]
[TD]Q2[/TD]
[TD]Q2[/TD]
[TD]Q2[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Asia[/TD]
[TD]Billable[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]Europe[/TD]
[TD]Unbillable[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]America[/TD]
[TD]Billable[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]Europe[/TD]
[TD]Billable[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]Asia[/TD]
[TD]Unbillable[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]35[/TD]
[/TR]
</tbody>[/TABLE]
Many thanks for your help!
John
Im looking to do a sumif on the below data where I sum the values that correspond to a particular region, whether its billable or unbillable and it relates to either Q1 or Q2.
Is this possible with sumifs? Will this require an array formula?
[TABLE="width: 455"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Region[/TD]
[TD]Billable / Non Billable[/TD]
[TD]Q1[/TD]
[TD]Q1[/TD]
[TD]Q1[/TD]
[TD]Q1[/TD]
[TD]Q2[/TD]
[TD]Q2[/TD]
[TD]Q2[/TD]
[TD]Q2[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Asia[/TD]
[TD]Billable[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]Europe[/TD]
[TD]Unbillable[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]America[/TD]
[TD]Billable[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]Europe[/TD]
[TD]Billable[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]Asia[/TD]
[TD]Unbillable[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]35[/TD]
[/TR]
</tbody>[/TABLE]
Many thanks for your help!
John