productkey
|
getegory
|
Type
|
Color
|
Items
|
price
|
sole
|
Totals
|
pdk-104
|
bag
|
Woman
|
blue
|
6
|
1200
|
2
|
2400
|
pdk-103
|
bag
|
Woman
|
pink
|
3
|
1250
|
2
|
2500
|
pdk-101
|
bag
|
Woman
|
red
|
5
|
1200
|
3
|
3600
|
pdk-102
|
bag
|
Woman
|
yellow
|
10
|
1200
|
5
|
6000
|
pdk-109
|
dress
|
Woman
|
cream
|
12
|
750
|
7
|
5250
|
pdk-108
|
dress
|
Woman
|
red
|
14
|
750
|
12
|
9000
|
pdk-107
|
dress
|
Woman
|
brow
|
25
|
1600
|
18
|
28800
|
pdk-116
|
jeans
|
children
|
black
|
4
|
600
|
4
|
2400
|
pdk-110
|
jeans
|
Woman
|
lightblue
|
6
|
750
|
6
|
4500
|
pdk-113
|
jeans
|
children
|
blue
|
12
|
700
|
9
|
6300
|
pdk-114
|
jeans
|
Woman
|
black
|
12
|
1200
|
9
|
10800
|
pdk-115
|
jeans
|
man
|
black
|
15
|
1000
|
15
|
15000
|
pdk-112
|
jeans
|
Woman
|
blue
|
20
|
1200
|
18
|
21600
|
pdk-111
|
jeans
|
Woman
|
blue
|
30
|
1300
|
25
|
32500
|
pdk-105
|
sunglass
|
Woman
|
green
|
4
|
1250
|
3
|
3750
|
pdk-106
|
sunglass
|
man
|
black
|
20
|
1500
|
14
|
21000
|
ຟັງຊັນການຄິດຄ່າຄຳນວນ
|
||
Maximum
|
32,500
|
ຍອດຂາຍສູງສຸດ
|
Minimum
|
2,400
|
ຍອດຂາຍຕ່ຳສຸດ
|
Average
|
10,963
|
ຍອດຂາຍສະເລ່ຍ
|
Count
|
16
|
ນັບຈຳນວນຍອດຂາຍສິນຄ້າ
|
Count
if
|
10,892
|
ຫາຄ່າສະເລ່ຍສີນຄ້າຜູ້ຍິງ(woman)
|
Sumif
|
14,500
|
ຫາຜົນລວມຍອດຂາຍກະເປົາ (bag)
|
| =MIN(H2:H17) | ||
| =MAX(H2:H17) | ||
| =AVERAGE(H2:H17) | ||
| =COUNT(H2:H17) | ||
| =AVERAGEIF(C2:C17,C8,H2:H17) | ||
| =SUMIF(B2:B17,B4,H2:H17) | ||
| Downloadສູດ | ||
0 comments:
Post a Comment