Hello,
I can't seem to create a correct formula for in cases where summing column D "sales target" of only "Division A" (Column A) if Value in column C is greater than value in Column B
This didn't work
=SUMIFS(D3:D60,A3:A160,"A",C3:C160,">B3:B160,B3")
Please help!
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Division[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 134"]
<tbody>[TR]
[TD="class: xl65, width: 134"]Planned Launch Date[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 134"]
<tbody>[TR]
[TD="class: xl65, width: 134"]Actual Launch Date[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 123"]
<tbody>[TR]
[TD="class: xl65, width: 123"]Sales Target[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]$1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]$6000[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]$0[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]$0[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]7[/TD]
[TD]0[/TD]
[TD]$25000[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]$4000[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]$5000[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]$4000[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]$3000[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]$5000[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]$2000[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]$3000[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]$2000[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]$1000[/TD]
[/TR]
</tbody>[/TABLE]
I can't seem to create a correct formula for in cases where summing column D "sales target" of only "Division A" (Column A) if Value in column C is greater than value in Column B
This didn't work
=SUMIFS(D3:D60,A3:A160,"A",C3:C160,">B3:B160,B3")
Please help!
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Division[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 134"]
<tbody>[TR]
[TD="class: xl65, width: 134"]Planned Launch Date[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 134"]
<tbody>[TR]
[TD="class: xl65, width: 134"]Actual Launch Date[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 123"]
<tbody>[TR]
[TD="class: xl65, width: 123"]Sales Target[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]$1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]$6000[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]$0[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]$0[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]7[/TD]
[TD]0[/TD]
[TD]$25000[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]$4000[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]$5000[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]$4000[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]$3000[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]$5000[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]$2000[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]$3000[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]$2000[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]$1000[/TD]
[/TR]
</tbody>[/TABLE]