Hi experts,
I need combined formula in column D with Sumifs and rank based on the given data sheet and shown result.
Data
Result
I need combined formula in column D with Sumifs and rank based on the given data sheet and shown result.
Data
Actual/Plan | Area | Description | Year | Volume | Turnover US$ | Std Cost US$ | Std Gross Profit US$ | GM CPL |
Actuals | Area Manager 1 | SetJet 50 CD Bulk | 2020 | 2,000 | 114,918 | 112,010 | 2,908 | 1.45 |
Actuals | Area Manager 1 | SetJet 50 CD 1 ltr | 2021 | 4,563 | 305,906 | 306,020 | (114) | (0.03) |
Actuals | Area Manager 1 | SetPlus 20W50 CF4 1 ltr | 2021 | 407 | 27,720 | 26,162 | 1,558 | 3.83 |
Actuals | Area Manager 1 | SetJet 50 CD Bulk | 2020 | 2,000 | 114,918 | 115,121 | (203) | (0.10) |
Actuals | Area Manager 1 | SetJet 50 CD 1 ltr | 2021 | 6,676 | 447,513 | 457,201 | (9,688) | (1.45) |
Actuals | Area Manager 4 | BetJet 20W50 CNG CD 4 ltr | 2020 | 5,523 | 566,690 | 566,000 | 690 | 0.12 |
Actuals | Area Manager 5 | BetJet 20W50 CNG CD 4 ltr | 2021 | 23,942 | 2,456,617 | 2,300,000 | 156,617 | 6.54 |
Result
Area | Description | Year | Volume |
Area Manager 5 | BetJet 20W50 CNG CD 4 ltr | 2021 | 23,942 |
Area Manager 1 | SetJet 50 CD 1 ltr | 2021 | 6,676 |
Area Manager 1 | SetJet 50 CD 1 ltr | 2021 | 4,563 |
Area Manager 1 | SetPlus 20W50 CF4 1 ltr | 2021 | 407 |