nasioedoeq
New Member
- Joined
- Apr 15, 2019
- Messages
- 6
Hi All,
I have problem in using excel formula to provide the correct result for my store performance.
I already googling some formula, both Excel and Google Sheet but it make me confused because some formula didn't work.
From that references I am using syntax Sumproduct, Sumif, Index and Match but it dont provide the correct result.
Any suggestion?
NB: Here is my sheet
<tbody>
</tbody>
I have problem in using excel formula to provide the correct result for my store performance.
I already googling some formula, both Excel and Google Sheet but it make me confused because some formula didn't work.
From that references I am using syntax Sumproduct, Sumif, Index and Match but it dont provide the correct result.
Any suggestion?
NB: Here is my sheet
Store Location | Item Name | Sold | Category | ||||
Wakanda | Candy A | 21295 | Candy | Candy A | Candy B | ||
Wakanda | Candy B | 3399 | T Shirt | T Shirt C | T Shirt D | ||
Wakanda | T Shirt C | 5393 | Shoes | Shoes Y | Shoes Z | ||
Wakanda | T Shirt D | 508 | Hat | Hat L | Hat M | Hat N | |
Wakanda | Shoes Y | 642 | Gloves | Gloves F | Gloves G | Gloves H | |
Wakanda | Shoes Z | 10 | |||||
Gotham | Candy A | 194 | |||||
Gotham | Candy B | 2910 | |||||
Gotham | T Shirt C | 664 | |||||
Gotham | T Shirt D | 760 | Store Performance | Category | Sold | ||
Gotham | Shoes Y | 0 | Wakanda | Candy | ? | ||
Gotham | Shoes Z | 0 | Wakanda | T Shirt | ? | ||
Gotham | Hat L | 83 | Wakanda | Shoes | ? | ||
Gotham | Hat M | 282 | Wakanda | Hat | ? | ||
Gotham | Hat N | 212 | Wakanda | Gloves | ? | ||
Gotham | Gloves F | 33440 | Gotham | Candy | ? | ||
Gotham | Gloves G | 185 | Gotham | T Shirt | ? | ||
Gotham | Gloves H | 22 | Gotham | Shoes | ? | ||
Smallville | Candy A | 501 | Gotham | Hat | ? | ||
Smallville | Candy B | 2289 | Gotham | Gloves | ? | ||
Smallville | T Shirt C | 701 | Smallville | Candy | ? | ||
Smallville | T Shirt D | 4941 | Smallville | T Shirt | ? | ||
Smallville | Shoes Y | 7 | Smallville | Shoes | ? | ||
Smallville | Shoes Z | 2245 | Smallville | Hat | ? | ||
Smallville | Hat L | 5960 | Smallville | Gloves | ? | ||
Smallville | Hat M | 1091 |
<tbody>
</tbody>