Spreadsheet: 763191d1642034289-formula-calculation-with-multiple-conditions-utilize-lookup-tables-to-return-percentage-of-total-kh99523-
Sheet: Sheet1

 |  |  |  | Number of Fields each customer owns of respective Crop |  |  |  |  |  |  |  |  |  | Use
 | Customer | Product Name (ENG) | Price Paid | Corn | Cereals | Vine | Apples | [NAME] | Carrots |  | Product Name | Crop |  | Customer | Product Name (ENG) | Corn | Cereals | Vine | Apples | [NAME] | Carrots
 | A | ADENGO SC465 | 100 | 57.69230769230769 | 184.6153846153846 | 57.69230769230769 | 0 | 0 | 0 |  | ADENGO SC465 | Corn |  | A | ADENGO SC465
 | B | BETANAL EXPERT EC274 | 200 | 95.88340577857326 | 97.49424699565327 | 0 | 49.09230375862951 | 57.53004346714395 | 0 |  | BELT SC480 | Corn |  | B | BETANAL EXPERT EC274
 | C | BELT SC480 | 300 | 57.69230769230769 | 184.6153846153846 | 57.69230769230769 | 0 | 0 | 0 |  | BELT SC480 | Carrots |  | C | BELT SC480
 | D | BELT SC480 | 400 | 63.64922206506365 | 172.7015558698727 | 63.64922206506365 | 0 | 0 | 0 |  | BELT SC480 | Vine |  | D | BELT SC480
 | E | ADENGO SC465 | 500 | 63.64922206506365 | 172.7015558698727 | 63.64922206506365 | 0 | 0 | 0 |  | BELT SC480 | Cereals |  | E | ADENGO SC465
 | F | ADENGO SC465 | 600 | 40.74074074074074 | 185.1851851851852 | 74.07407407407408 | 0 | 0 | 0 |  | BETANAL EXPERT EC274 | Cereals |  | F | ADENGO SC465
 | G | TILMOR EC240 | 700 | 72.35256816740647 | 109.7019657577679 | 0 | 46.29042485732403 | 64.04565630944832 | 7.609384908053266 |  | PROPULSE SE250 | [NAME] |  | G | TILMOR EC240
 | H | PROPULSE SE250 | 800 | 63.64922206506365 | 172.7015558698727 | 63.64922206506365 | 0 | 0 | 0 |  | PROPULSE SE250 | Apples |  | H | PROPULSE SE250
 |  |  |  |  |  |  |  |  |  |  | PROPULSE SE250 | Vine
 |  |  |  |  |  |  |  |  |  |  | TILMOR EC240 | Apples |  | Percent
 | Manual Solution |  |  | Revenue generated per customer with each crop |  |  |  |  |  |  | TILMOR EC240 | Vine |  | Customer | Product Name (ENG) | Corn | Cereals | Vine | Apples | [NAME] | Carrots
 | Customer | Product Name (ENG) | Price Paid | Corn | Cereals | Vine | Apples | [NAME] | Carrots |  |  |  |  | A | ADENGO SC465
 | A | ADENGO SC465 | 100 | 100 |  |  |  |  |  |  |  |  |  | B | BETANAL EXPERT EC274
 | B | BETANAL EXPERT EC274 | 200 |  | 200 |  |  |  |  |  |  |  |  | C | BELT SC480
 | C | BELT SC480 | 300 | 57.69230769230769 | 184.6153846153846 | 57.69230769230769 |  |  |  |  |  |  |  | D | BELT SC480
 | D | BELT SC480 | 400 | 84.86562942008487 | 230.2687411598303 | 84.86562942008487 |  |  |  |  |  |  |  | E | ADENGO SC465
 | E | ADENGO SC465 | 500 | 500 |  |  |  |  |  |  |  |  |  | F | ADENGO SC465
 | F | ADENGO SC465 | 600 | 600 |  |  |  |  |  |  |  |  |  | G | TILMOR EC240
 | G | TILMOR EC240 | 700 |  |  |  | 700 |  |  |  |  |  |  | H | PROPULSE SE250
 | H | PROPULSE SE250 | 800 |  |  | 800
 | [NAME] E27:J35 |  |  | Revenue generated per customer with each crop
 | Customer | Product Name (ENG) | Price Paid | Corn | Cereals | Vine | Apples | [NAME] | Carrots
 | A | ADENGO SC465 | 100
 | B | BETANAL EXPERT EC274 | 200
 | C | BELT SC480 | 300
 | D | BELT SC480 | 400
 | E | ADENGO SC465 | 500
 | F | ADENGO SC465 | 600
 | G | TILMOR EC240 | 700
 | H | PROPULSE SE250 | 800