Yr | Per | Client | Amount | |
East | 2018 | 1 | CXYZ001 | 1562.00 |
East | 2018 | 5 | CBLG070 | 596.55 |
East | 2018 | 1 | CXYZ001-10 | 8251.99 |
East | 2018 | 1 | CBLG070 | 9426.33 |
East | 2018 | 5 | CXYZ001-15 | 7491.76 |
<tbody>
</tbody>
I have 4 worksheets with the same data per region. I need to sum sales by customer per period across all 4 worksheets into one single line in my summary sheet. In addition I need my formula to only look at the first 7 characters of the client code.
So, in summary I need a formula that will sum sales
If region = East go to worksheet 1 and sum sales if customer = CXYZ001 and period =1
Any suggestions?