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):
<tbody>
</tbody>
This is what the tab Apple looks like (the other tabs look the same but with diff. customers):
<tbody>
</tbody>
I hope this is clear. Thank you!
This is what the consolidate tab looks like (I am trying to solve for the question marks):
Tab | Customer | Value | January | February |
Apple | A | Price | ? | ? |
Apple | A | Code | ? | ? |
Banana | F | Price | ? | ? |
Banana | F | Code | ? | ? |
Citrus | K | Price | ? | ? |
Citrus | K | Code | ? | ? |
<tbody>
</tbody>
This is what the tab Apple looks like (the other tabs look the same but with diff. customers):
Customer | ||||
A | January | February | March | April |
Price | 1 | 2 | 3 | 4 |
Code | 2 | 2 | 2 | 2 |
B | January | February | March | April |
Price | 1 | 2 | 3 | 4 |
Code | 2 | 2 | 2 | 2 |
C | January | February | March | April |
Price | 1 | 2 | 3 | 4 |
Code | 2 | 2 | 2 | 2 |
<tbody>
</tbody>
I hope this is clear. Thank you!
Last edited: