Hi I am trying to consolidate multiple sheets into 1 tab. I don't know how to use the sumif because 2 of my criteria are in the same column: the customer name and the value name. I don't even know exactly what formula to use...all help would be appreciated. I am trying to consolidate data in tabs A thru E in the last (Consolidate) tab.
This is what the consolidate tab looks like (I am trying to solve for the question marks):
[TABLE="width: 345"]
<tbody>[TR]
[TD="class: xl63, width: 69, align: center"]Tab[/TD]
[TD="class: xl63, width: 69, align: center"]Customer[/TD]
[TD="class: xl63, width: 69, align: center"]Value[/TD]
[TD="class: xl63, width: 69, align: center"]January[/TD]
[TD="class: xl63, width: 69, align: center"]February[/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]Apple[/TD]
[TD="class: xl64, align: center"]A[/TD]
[TD="align: center"]Price[/TD]
[TD="class: xl65, align: center"]?[/TD]
[TD="class: xl65, align: center"]?[/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]Apple[/TD]
[TD="class: xl64, align: center"]A[/TD]
[TD="align: center"]Code[/TD]
[TD="class: xl65, align: center"]?[/TD]
[TD="class: xl65, align: center"]?[/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]Banana[/TD]
[TD="class: xl64, align: center"]F[/TD]
[TD="align: center"]Price[/TD]
[TD="class: xl65, align: center"]?[/TD]
[TD="class: xl65, align: center"]?[/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]Banana[/TD]
[TD="class: xl64, align: center"]F[/TD]
[TD="align: center"]Code[/TD]
[TD="class: xl65, align: center"]?[/TD]
[TD="class: xl65, align: center"]?[/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]Citrus[/TD]
[TD="class: xl64, align: center"]K[/TD]
[TD="align: center"]Price[/TD]
[TD="class: xl65, align: center"]?[/TD]
[TD="class: xl65, align: center"]?[/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]Citrus[/TD]
[TD="class: xl64, align: center"]K[/TD]
[TD="align: center"]Code[/TD]
[TD="class: xl65, align: center"]?[/TD]
[TD="class: xl65, align: center"]?[/TD]
[/TR]
</tbody>[/TABLE]
This is what the tab Apple looks like (the other tabs look the same but with diff. customers):
[TABLE="width: 354"]
<tbody>[TR]
[TD="align: center"]Customer[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]January[/TD]
[TD="align: center"]February[/TD]
[TD="align: center"]March[/TD]
[TD="align: center"]April[/TD]
[/TR]
[TR]
[TD="align: center"]Price[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD="align: center"]Code[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]B[/TD]
[TD="align: center"]January[/TD]
[TD="align: center"]February[/TD]
[TD="align: center"]March[/TD]
[TD="align: center"]April[/TD]
[/TR]
[TR]
[TD="align: center"]Price[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD="align: center"]Code[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]C[/TD]
[TD="align: center"]January[/TD]
[TD="align: center"]February[/TD]
[TD="align: center"]March[/TD]
[TD="align: center"]April[/TD]
[/TR]
[TR]
[TD="align: center"]Price[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD="align: center"]Code[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[/TR]
</tbody>[/TABLE]
I hope this is clear. Thank you!
This is what the consolidate tab looks like (I am trying to solve for the question marks):
[TABLE="width: 345"]
<tbody>[TR]
[TD="class: xl63, width: 69, align: center"]Tab[/TD]
[TD="class: xl63, width: 69, align: center"]Customer[/TD]
[TD="class: xl63, width: 69, align: center"]Value[/TD]
[TD="class: xl63, width: 69, align: center"]January[/TD]
[TD="class: xl63, width: 69, align: center"]February[/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]Apple[/TD]
[TD="class: xl64, align: center"]A[/TD]
[TD="align: center"]Price[/TD]
[TD="class: xl65, align: center"]?[/TD]
[TD="class: xl65, align: center"]?[/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]Apple[/TD]
[TD="class: xl64, align: center"]A[/TD]
[TD="align: center"]Code[/TD]
[TD="class: xl65, align: center"]?[/TD]
[TD="class: xl65, align: center"]?[/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]Banana[/TD]
[TD="class: xl64, align: center"]F[/TD]
[TD="align: center"]Price[/TD]
[TD="class: xl65, align: center"]?[/TD]
[TD="class: xl65, align: center"]?[/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]Banana[/TD]
[TD="class: xl64, align: center"]F[/TD]
[TD="align: center"]Code[/TD]
[TD="class: xl65, align: center"]?[/TD]
[TD="class: xl65, align: center"]?[/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]Citrus[/TD]
[TD="class: xl64, align: center"]K[/TD]
[TD="align: center"]Price[/TD]
[TD="class: xl65, align: center"]?[/TD]
[TD="class: xl65, align: center"]?[/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]Citrus[/TD]
[TD="class: xl64, align: center"]K[/TD]
[TD="align: center"]Code[/TD]
[TD="class: xl65, align: center"]?[/TD]
[TD="class: xl65, align: center"]?[/TD]
[/TR]
</tbody>[/TABLE]
This is what the tab Apple looks like (the other tabs look the same but with diff. customers):
[TABLE="width: 354"]
<tbody>[TR]
[TD="align: center"]Customer[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]January[/TD]
[TD="align: center"]February[/TD]
[TD="align: center"]March[/TD]
[TD="align: center"]April[/TD]
[/TR]
[TR]
[TD="align: center"]Price[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD="align: center"]Code[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]B[/TD]
[TD="align: center"]January[/TD]
[TD="align: center"]February[/TD]
[TD="align: center"]March[/TD]
[TD="align: center"]April[/TD]
[/TR]
[TR]
[TD="align: center"]Price[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD="align: center"]Code[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]C[/TD]
[TD="align: center"]January[/TD]
[TD="align: center"]February[/TD]
[TD="align: center"]March[/TD]
[TD="align: center"]April[/TD]
[/TR]
[TR]
[TD="align: center"]Price[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD="align: center"]Code[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[/TR]
</tbody>[/TABLE]
I hope this is clear. Thank you!
Last edited: