Imp Formulas

1 Subtotal 11 Unique 21 Sum + Vlookup

2 Sumproduct 12 Countif 22 Xlookup
3 Datedif 13 Countifs 23 Picture Lookup
4 IF 14 Averageifs 24 Sort
5 IF + And 15 Vlookup 25 Filter
6 IF + OR 16 Iferror 26 Trim Magic
7 IFS 17 Hlookup 27 Dynamic
8 Switch 18 Index 28 Textsplit
9 Sumif 19 Match 29 Textjoin
10 Sumifs 20 Index + Match 30 Protect

30+ Advanced Excel Formulas

#1 Subtotal Formula
Item_ID Item_Name Region
100 Mouse East
101 Keyboard Wesr
102 Ring Light 12 Inch North
103 Softbox East
104 Mouse Wesr
105 Keyboard North
106 Hard Disk (2TB) South
107 Mouse North
108 Keyboard North
109 Mouse Pad South
110 Mouse Wesr
Price Qty Amount
220 10 2200
300 12 3600
799 100 79900
1500 10 15000
450 100 45000
45999 15 689985
4500 20 90000
199 11 2189
399 40 15960
49 34 1666
799 11 8789

TOTAL 363 954289

#2 Sumproduct Formula
Item_ID Item_Name Region
100 Mouse East
101 Keyboard Wesr
102 Ring Light 12 Inch North
103 Softbox East
104 Tripod Wesr
105 Laptop ( i5,Ryzan 5, 1TB ) North
106 Hard Disk (2TB) South
107 Mobile Stand North
108 Laptop Stand North
109 Mouse Pad South
110 RGB Keyboard Wesr
Price Qty Amount
220 10
300 12
799 100
1500 10
450 100
45999 15
4500 20
199 11
399 40
49 34
799 11

Total Amount 954289

#3 Datedif Formula
D.O.B. Today Date
1/1/2000 7/20/2024
5/4/2005 7/20/2024
6/5/2022 7/20/2024
mula
Age Year (Y) Month (YM)
24 Years, 6 Months, 19 Days 24 6
19 Years, 2 Months, 16 Days 19 2
2 Years, 1 Months, 15 Days 2 1
Days (MD) Total Month (M)Total Days (D)
19 294 8967
16 230 7017
15 25 776
#4 IF Formula
Stu_Name Marks Result Status
Raj 45
Anil Lumar 65
Naresh 11 Fail
Aman 87
Sunil Kumar 33 Fail

Stu_Name Marks Grace Marks 5

Raj 45 45
Anil Lumar 65 65
Naresh 11 16
Aman 87 87
Sunil Kumar 33 38

Emp_Name Working Shift Salary

Raj Morning 10000
Anil Lumar Evening 12000
Naresh Night 20000
Aman Morning 18000
Sunil Kumar Night 15000
 1# if student marks is grater than or equal to 40, display
result status "PASS" otherwise display result status
"FAIL"
2# if student marks is less than 40, display "FAIL"
otherwise leave the cell blank

3# Extract the name of failed students (marks<40)

4# Add 5 grace marks if student marks is less than 40

New Salary 5# Increase 5% salary of employees whose

10000 working shift is NIGHT
12000
21000
18000
15750
#5 IF + AND Formula
Stu_Name Phy Che
Raj 45 45
Anil Lumar 65 45
Naresh 11 55
Aman 87 66
Sunil Kumar 33 34

Order No. Progress Delivery Date

10 Delivered 7/20/2024
11 In Transit
12 Delivered 7/19/2024
13 Delivered
14 In Transit 7/19/2024

Order No. Amount Status

10 ₹ 4,000 Closed
11 ₹ 12,000 Closed
12 ₹ 33,000 Open
13 ₹ 3,400 Closed
14 ₹ 17,000 Open
Math Result Status #1 If student obtained marks grater tha
88 Pass eqaul to 40 in all subjects, display re
77 Pass status "PASS" otherwise display "FAI
23 Fail
33 Fail
75 Fail

Status #2 Display the status CLOSED if progress is "deli

Closed and delivery date is not empty

Closed

Cashback #3 Calculate the Cashback of 5% for CLOSED Ord

with the amount grater than or equal to 10,00
₹ 600
ained marks grater than or
all subjects, display result
otherwise display "FAIL"

SED if progress is "delivered"

t empty

of 5% for CLOSED Orders

than or equal to 10,000
#6 IF + OR Formula
Order No. QTY Unit Price Discount (5%)
10 23 200 Yes
11 9 1500 Yes
12 8 200 No
13 5 1299 Yes
14 17 150 Yes

Indicate the discounted orders (Yes/No) and Apply 5% discount if e

1 : if QTY is grater than or eqal to 15, OR

2: Unit price is grater than or equal to 1200.

Order No. Progress Status

10 Delivered Closed
11 In Transit
12 Delivered Closed
13 Cancelled Closed
14 Cancelled Closed

Display the status CLOSED if progress is "delivered" or "cancelled"

 Total Amount
4370 4600
12825 13500
1600
6170.25 6495
2422.5 2550

5% discount if either of these condition is met. Otherwise return full price.

" or "cancelled"
turn full price.
#7 IFs Formula
Stu_Name Marks Grade
Raj 45% D
Anil Lumar 65% B
Naresh 11% D
Aman 87% A
Sunil Kumar 33% D

Grading Scale :
Equal to or grater than 80% =A
Equal to or grater than 60% =B
Equal to or grater than 50% =c
Less than 50%=D

Saller Sales Cmmission ?

A 12000 2%
B 57000 5%
E 120000 10%
D 34000 2%

Sales grater than or equal to 100000 = 10%

Sales grater than or equal to 50000 = 5%
Less Than 50000 = 2%
#8 Switch Formula
Product Rating Status
Raj 5 Excellent
Anil Lumar 2 Poor
Naresh 7 unknown
Aman 7 unknown
Sunil Kumar 4 Very Good

Rating Scale :
Equal to 5 = Excellent
Equal to 4= Very Good
Equal to 3= Good
Equal to 2= Poor
Equal to 1= Very Poor

Product ID Product_Name Category

10 Wallpaper Décor
11 Coffee Mug Kitchen
12 Laptop Desk Office
13 Juicer Kitchen
14 Yoga Mat Fitness
15 Dinner Set Kitchen
Discount % Category Discount %
17.00% Fitness 15%
12.00% Office 5%
5.00% Kitchen 12%
12.00% Décor 17%
15.00%
12.00%
#9 Sumif Formula
Order_ID Product_Name Seller_Name
100 Mobile Stand Bharat Electronics
101 Mouse Pad Tech Mart
102 Mouse Bharat Electronics
103 Wireless Mouse Tech Mart
104 Ring Light Store 99
105 Keyboard Bharat Electronics
106 Wireless Keyboard Tech Mart
107 Mouse Store 100
108 Keyboard Bharat Electronics
109 Ring Light Tech Mart
110 RGB Keyboard Store 101
QTY Price Product_Name Total QTY
10 70 RGB Keyboard 7
12 40
5 210
5 599 Seller_Name Total QTY Sold
8 1250 Bharat Electronics 40
20 300
50 799
10 200
5 310
12 1500
7 999
#10 Sumifs Formula
Order_ID Product_Name Seller_Name
100 Mobile Stand Bharat Electronics
101 Mouse Pad Tech Mart
102 Mouse Bharat Electronics
103 Wireless Mouse Tech Mart
104 Ring Light Store 99
105 Keyboard Bharat Electronics
106 Wireless Keyboard Tech Mart
107 Mouse Store 100
108 Keyboard Bharat Electronics
109 Ring Light Tech Mart
110 RGB Keyboard Store 101

Region Product_Name Seller_Name

East Mobile Stand Bharat Electronics
West Mouse Pad Tech Mart
North Mouse Bharat Electronics
South Wireless Mouse Tech Mart
East Ring Light Store 99
West Keyboard Bharat Electronics
North Wireless Keyboard Tech Mart
South Mouse Store 100
East Keyboard Bharat Electronics
West Ring Light Tech Mart
QTY Price Product_Name Seller_Name
10 70 Keyboard Bharat Electronics
12 40
5 210
5 599
8 1250
20 300
50 799
10 200
5 310
12 1500
7 999

QTY Price Region Product_Name

10 70 East Ring Light
12 40
5 210
5 599
8 1250
20 300
50 799
10 200
5 310
12 1500
Total QTY
25

QTY
8
#11 Unique Formula
Order_ID Product_Name Seller_Name
100 Mobile Stand Bharat Electronics
101 Mouse Pad Tech Mart
102 Mouse Bharat Electronics
103 Wireless Mouse Tech Mart
104 Ring Light Store 99
105 Keyboard Bharat Electronics
106 Wireless Keyboard Tech Mart
107 Mouse Store 100
108 Keyboard Bharat Electronics
109 Ring Light Tech Mart
110 RGB Keyboard Store 101

#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
QTY Price Product_Name Total QTY
10 70 Keyboard
12 40
5 210
5 599 Seller_Name Total QTY Sold
8 1250 #NAME? 40
20 300 #NAME?
50 799 #NAME?
10 200 #NAME?
5 310 #NAME?
12 1500
7 999
#12 Countif Formula
Order_ID Product_Name Seller_Name
100 Mobile Stand Bharat Electronics
101 Mouse Pad Tech Mart
102 Mouse Bharat Electronics
103 Wireless Mouse Tech Mart
104 Keyboard Store 99
105 Keyboard Bharat Electronics
106 Keyboard Tech Mart
107 Mouse Store 100
108 Keyboard Bharat Electronics
109 Ring Light Tech Mart
110 RGB Keyboard Store 101
QTY Price Product_Name Total Orders
10 70 keyboard 4
12 40
5 210
5 599 Seller_Name Total Orders
8 1250 Tech Mart 4
20 300
50 799
10 200
5 310
12 1500
7 999
#13 Countifs Formula
Order_ID Product_Name Seller_Name
100 Mobile Stand Bharat Electronics
101 Mouse Pad Tech Mart
102 Mouse Bharat Electronics
103 Wireless Mouse Tech Mart
104 Ring Light Store 99
105 Keyboard Bharat Electronics
106 Wireless Keyboard Tech Mart
107 Mouse Store 100
108 Keyboard Bharat Electronics
109 Ring Light Tech Mart
110 RGB Keyboard Store 101

Region Product_Name Seller_Name

East Mobile Stand Bharat Electronics
West Mouse Pad Tech Mart
North Mouse Bharat Electronics
South Wireless Mouse Tech Mart
East Ring Light Store 99
West Keyboard Bharat Electronics
North Wireless Keyboard Tech Mart
South Mouse Store 100
East Keyboard Bharat Electronics
West Ring Light Tech Mart
QTY Price Product_Name Seller_Name
10 70 Mouse Bharat Electronics
12 40
5 210
5 599
8 1250
20 300
50 799
10 200
5 310
12 1500
7 999

QTY Price Region Product_Name

10 70 South Wireless Mouse
12 40
5 210
5 599
8 1250
20 300
50 799
10 200
5 310
12 1500
Total Orders
1

QTY
1
#14 Averageifs Formula
Order_ID Product_Name Seller_Name
100 Mobile Stand Bharat Electronics
101 Mouse Pad Tech Mart
102 Mouse Bharat Electronics
103 Mouse Tech Mart
104 Mouse Store 99
105 Mouse Bharat Electronics
106 Wireless Keyboard Tech Mart
107 Mouse Store 100
108 Keyboard Bharat Electronics
109 Ring Light Tech Mart
110 RGB Keyboard Store 101

Region Product_Name Seller_Name

East Mobile Stand Bharat Electronics
West Mouse Pad Tech Mart
North Mouse Bharat Electronics
South Wireless Mouse Tech Mart
East Ring Light Store 99
West Keyboard Bharat Electronics
North Wireless Keyboard Tech Mart
South Mouse Store 100
East Keyboard Bharat Electronics
West Ring Light Tech Mart
QTY Price Product_Name Seller_Name
10 70 Mouse Bharat Electronics
12 40
5 210
5 599
8 1250
20 300
50 799
10 200
5 310
12 1500
7 999

QTY Price Region Product_Name

10 70
12 40
5 210
5 599
8 1250
20 300
50 799
10 200
5 310
12 1500
Qty Avg.
12.5

QTY
#15 Vlookup Formula
Order_ID Product_Name Amount
104 Ring Light 10000

Order_ID Product_Name Seller_Name

100 Mobile Stand Bharat Electronics
101 Mouse Pad Tech Mart
102 Mouse Bharat Electronics
103 Wireless Mouse Tech Mart
104 Ring Light Store 99
105 Keyboard Bharat Electronics
106 Wireless Keyboard Tech Mart
107 Speaker Store 100
108 Hard disk Bharat Electronics

Order_ID Seller_Name
102 Bharat Electronics

Product_Name Order_ID
Mobile Stand 100
Mouse Pad 101
Mouse 102
Wireless Mouse 103
Ring Light 104
Keyboard 105
Wireless Keyboard 106
Mouse 107
Keyboard 108

Order_ID Product_Name Seller_Name

104 Ring Light Store 99
Order_ID Product_Name Seller_Name
100 Mobile Stand Bharat Electronics
101 Mouse Pad Tech Mart
102 Mouse Bharat Electronics
103 Wireless Mouse Tech Mart
104 Ring Light Store 99
105 Keyboard Bharat Electronics
106 Wireless Keyboard Tech Mart
107 Speaker Store 100
108 Hard disk Bharat Electronics
 QTY Price Amount
10 70 700
12 40 480
5 210 1050
5 599 2995
8 1250 10000
20 300 6000
50 799 39950
10 200 2000
5 310 1550

tronics

Seller_Name QTY Price Amount

Bharat Electronics 10 70 700
Tech Mart 12 40 480
Bharat Electronics 5 210 1050
Tech Mart 5 599 2995
Store 99 8 1250 10000
Bharat Electronics 20 300 6000
Tech Mart 50 799 39950
Store 100 10 200 2000
Bharat Electronics 5 310 1550

QTY Price Amount

8 1250 10000
QTY Price Amount
10 70 700
12 40 480
5 210 1050
5 599 2995
8 1250 10000
20 300 6000
50 799 39950
10 200 2000
5 310 1550
#16 Iferror Formula
Order_ID Product_Name
200 record not found

Order_ID Product_Name Seller_Name

100 Mobile Stand Bharat Electronics
101 Mouse Pad Tech Mart
102 Mouse Bharat Electronics
103 Wireless Mouse Tech Mart
104 Ring Light Store 99
105 Keyboard Bharat Electronics
106 Wireless Keyboard Tech Mart
107 Speaker Store 100
108 Hard disk Bharat Electronics

Order_ID Product_Name

Product_Name Order_ID
Mobile Stand 100
Mouse Pad 101
Mouse 102
Wireless Mouse 103
Ring Light 104
Keyboard 105
Wireless Keyboard 106
Mouse 107
Keyboard 108

Order_ID Product_Name Seller_Name

200 record not found record not found
Order_ID Product_Name Seller_Name
100 Mobile Stand Bharat Electronics
101 Mouse Pad Tech Mart
102 Mouse Bharat Electronics
103 Wireless Mouse Tech Mart
104 Ring Light Store 99
105 Keyboard Bharat Electronics
106 Wireless Keyboard Tech Mart
107 Speaker Store 100
108 Hard disk Bharat Electronics
QTY Price Amount
10 70 700
12 40 480
5 210 1050
5 599 2995
8 1250 10000
20 300 6000
50 799 39950
10 200 2000
5 310 1550

Seller_Name QTY Price Amount

Bharat Electronics 10 70 700
Tech Mart 12 40 480
Bharat Electronics 5 210 1050
Tech Mart 5 599 2995
Store 99 8 1250 10000
Bharat Electronics 20 300 6000
Tech Mart 50 799 39950
Store 100 10 200 2000
Bharat Electronics 5 310 1550

QTY Price Amount

record not found record not found record not found
QTY Price Amount
10 70 700
12 40 480
5 210 1050
5 599 2995
8 1250 10000
20 300 6000
50 799 39950
10 200 2000
5 310 1550
#17 Hlookup Formula
Order_ID price
105

Order_ID Product_Name Seller_Name

100 Mobile Stand Bharat Electronics
101 Mouse Pad Tech Mart
102 Mouse Bharat Electronics
103 Wireless Mouse Tech Mart
104 Ring Light Store 99
105 Keyboard Bharat Electronics

Order_ID Product_Name
100 Mobile Stand
101 Mouse Pad
102 Mouse
103 Wireless Mouse
104 Ring Light
105 Keyboard

Order_ID Product_Name Seller_Name

100 Mobile Stand Bharat Electronics
101 Mouse Pad Tech Mart
102 Mouse Bharat Electronics
103 Wireless Mouse Tech Mart
104 Ring Light Store 99
105 Keyboard Bharat Electronics
QTY Price Amount
10 70 700
12 40 480
5 210 1050
5 599 2995
8 1250 10000
20 300 6000

QTY Price Amount

10 70 700
12 40 480
5 210 1050
5 599 2995
8 1250 10000
20 300 6000
#18 Index Formula
Order_ID Product_Name Seller_Name
100 Mobile Stand Bharat Electronics
101 Mouse Pad Tech Mart
102 Mouse Bharat Electronics
103 Wireless Mouse Tech Mart
104 Ring Light Store 99
105 Keyboard Bharat Electronics

Row Column
1 2

QTY
10
12
5
5
8
20
QTY Price Amount
10 70 700
12 40 480
5 210 1050
5 599 2995
8 1250 10000
20 300 6000
#19 Match Formula
Order_ID Product_Name Seller_Name
100 Mobile Stand Bharat Electronics
101 Mouse Pad Tech Mart
102 Mouse Bharat Electronics
103 Wireless Mouse Tech Mart
104 Ring Light Store 99
105 Keyboard Bharat Electronics

105 7
qty 4
QTY Price Amount
10 70 700
12 40 480
5 210 1050
5 599 2995
8 1250 10000
20 300 6000
#20 Index+Match Formula
Order_ID Product_Name Seller_Name
100 Mobile Stand Bharat Electronics
101 Mouse Pad Tech Mart
102 Mouse Bharat Electronics
103 Wireless Mouse Tech Mart
104 Ring Light Store 99
105 Keyboard Bharat Electronics

Order_ID price
104

Order_ID Product_Name Seller_Name

104 Ring Light Store 99
QTY Price Amount
10 70 700
12 40 480
5 210 1050
5 599 2995
8 1250 10000
20 300 6000

QTY Price Amount

8 1250 10000
#21 Sum+Vlookup Formula
Product ID Jan Feb
10 12000 4000
11 23000 3000
12 12000 34000
13 2000 54000
14 33000 2000

Product ID Total Sale

12 52500
ormula
Mar
4500
5600
6500
45000
45000
#22 Xlookup Formula
Order_ID Product_Name Amount
101 Speaker

Order_ID Product_Name Seller_Name

100 Mobile Stand Bharat Electronics
101 Mouse Pad Tech Mart
102 Mouse Bharat Electronics
103 Wireless Mouse Tech Mart
104 Ring Light Store 99
105 Keyboard Bharat Electronics
106 Wireless Keyboard Tech Mart
101 Speaker Store 100
108 Hard disk Bharat Electronics

Order_ID Product_Name
104 Ring Light

Product_Name Order_ID
Mobile Stand 100
Mouse Pad 101
Mouse 102
Wireless Mouse 103
Ring Light 104
Keyboard 105
Wireless Keyboard 106
Mouse 107
Keyboard 108

Order_ID Product_Name Seller_Name

101 Mouse Pad Tech Mart
Order_ID Product_Name Seller_Name
100 Mobile Stand Bharat Electronics
101 Mouse Pad Tech Mart
102 Mouse Bharat Electronics
103 Wireless Mouse Tech Mart
104 Ring Light Store 99
105 Keyboard Bharat Electronics
106 Wireless Keyboard Tech Mart
107 Speaker Store 100
108 Hard disk Bharat Electronics

Region Jan Feb

East 12000 2300
West 44000 45000
North 1000 56000
South 54000 5400
Total 111000 108700

Month Total Sale

mar 130000
QTY Price Amount
10 70 700
12 40 480
5 210 1050
5 599 2995
8 1250 10000
20 300 6000
50 799 39950
10 200 2000
5 310 1550

Seller_Name QTY Price Amount

Bharat Electronics 10 70 700
Tech Mart 12 40 480
Bharat Electronics 5 210 1050
Tech Mart 5 599 2995
Store 99 8 1250 10000
Bharat Electronics 20 300 6000
Tech Mart 50 799 39950
Store 100 10 200 2000
Bharat Electronics 5 310 1550

QTY Price Amount

#NAME? #NAME? #NAME?
QTY Price Amount
10 70 700
12 40 480
5 210 1050
5 599 2995
8 1250 10000
20 300 6000
50 799 39950
10 200 2000
5 310 1550

Mar Apr
76000 45000
5600 56000
45000 6700
3400 7800
130000 115500
#23 Picture lookup Formula
Name Picture

MS Word

MS Excel

MS Powerpoint
mula
Name Picture

MS Powerpoint

0
#24 Sort Formula
Name Name
Raj Kumar #NAME?
Amit #NAME?
Sonu Sharma #NAME?
Minku Singh #NAME?
Mohit #NAME?
Tinku #NAME?
Sunil Kumar #NAME?
Lalit #NAME?
Yogi #NAME?

Order_ID Product_Name Qty Sold

104 Mobile Stand 23
102 Mouse Pad 17
101 Mouse 45
103 Wireless Mouse 4
100 Ring Light 31
105 Keyboard 12

Order_ID Product_Name Qty Sold

#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?

Raj Kumar Amit Sonu Sharma

#NAME? #NAME? #NAME?

Minku Singh Mohit Tinku Sunil Kumar

#NAME? #NAME? #NAME? #NAME?

nil Kumar
#25 Filter Formula

Date Product_Name Region QTY Sold

1/1/2024 Ring Light East 10
1/2/2024 Mouse Pad West 12
1/3/2024 Mouse North 5
1/4/2024 Wireless Mouse East 5
1/5/2024 Ring Light West 8
1/6/2024 Mouse West 20
1/7/2024 Ring Light East 50
1/8/2024 Speaker West 10
1/9/2024 Mouse North 5

Date Product_Name Region QTY Sold

1/1/2024 Ring Light East 10
1/2/2024 Mouse Pad West 12
1/3/2024 Mouse North 5
1/4/2024 Wireless Mouse East 5
1/5/2024 Ring Light West 8
1/6/2024 Mouse West 20
1/7/2024 Ring Light East 50
1/8/2024 Speaker West 10
1/9/2024 Mouse North 5
Product_Name Region
ring light west

Date Product_Name Region QTY Sold

#NAME? #NAME? #NAME? #NAME?

Start Date End Date

1/2/2024 1/4/2024

Date Product_Name Region QTY Sold

#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#26 Trim Formula
Order_ID Product_Name
mm108 Hard disk

Order_ID Product_Name Seller_Name

MM100 Mobile Stand Bharat Electronics
MM101 Mouse Pad Tech Mart
MM102 Mouse Bharat Electronics
MM103 Wireless Mouse Tech Mart
MM104 Ring Light Store 99
MM105 Keyboard Bharat Electronics
MM106 Wireless Keyboard Tech Mart
MM107 Speaker Store 100
MM108 Hard disk Bharat Electronics
Order_ID
#27 Dynamic Formula
Order_ID Product_Name
16 fgf

Order_ID Product_Name Seller_Name

10 Mobile Stand Bharat Electronics
11 Mouse Pad Tech Mart
12 Mouse Bharat Electronics
13 Wireless Mouse Tech Mart
14 Ring Light Store 99
15 Keyboard Bharat Electronics
16 fgf cbgf
#28 Textsplit Formula
Emp ID Name Age
202401 raj kumar 34
202402 naresh kumar 26
202403 amit 34
202404 sonu sharma 33
202405 tinku singh 27
202406 yogesh 44

Emp ID,Name,Age,Salary
202401,raj kumar,34,12000
202402,naresh kumar,26,20000
202403,amit,34,24000
202404,sonu sharma,33,20000
202405,tinku singh,27,11000
202406,yogesh,44,13500
Salary
12000
20000
24000
20000
11000
13500
#29 Textjoin, Concatenate Formula
Emp ID Name Age
202401 raj kumar 34
202402 naresh kumar 26
202403 amit 34
202404 sonu sharma 33
202405 tinku singh 27
202406 yogesh 44

First Name Middle name Last Name

Raj Kumar Singh
Amit Jain
Pankaj Singh

Emp ID,Name,Age,Salary
202401,raj kumar,34,12000
202402,naresh kumar,26,20000
202403,amit,34,24000
202404,sonu sharma,33,20000
202405,tinku singh,27,11000
202406,yogesh,44,13500
enate Formula
Salary
12000
20000
24000
20000
11000
13500

Raj Kumar Singh

Amit Jain
Pankaj Singh
#30 Protect Formulas
Order_ID Product_Name Amount
104 Ring Light 10000

Order_ID Product_Name Seller_Name

100 Mobile Stand Bharat Electronics
101 Mouse Pad Tech Mart
102 Mouse Bharat Electronics
103 Wireless Mouse Tech Mart
104 Ring Light Store 99
105 Keyboard Bharat Electronics
106 Wireless Keyboard Tech Mart
107 Speaker Store 100
108 Hard disk Bharat Electronics
Total

Order_ID Product_Name
102

Product_Name Order_ID
Mobile Stand 100
Mouse Pad 101
Mouse 102
Wireless Mouse 103
Ring Light 104
Keyboard 105
Wireless Keyboard 106
Mouse 107
Keyboard 108

Order_ID Product_Name Seller_Name

101
Order_ID Product_Name Seller_Name
100 Mobile Stand Bharat Electronics
101 Mouse Pad Tech Mart
102 Mouse Bharat Electronics
103 Wireless Mouse Tech Mart
104 Ring Light Store 99
105 Keyboard Bharat Electronics
106 Wireless Keyboard Tech Mart
107 Speaker Store 100
108 Hard disk Bharat Electronics

Region Jan Feb

East 12000 2300
West 44000 45000
North 1000 56000
South 54000 5400
Total 111000 108700

Month Total Sale

feb
fgh gh
fgh

QTY Price Amount

10 70 700
12 40 480
5 210 1050
5 599 2995
8 1250 10000
20 300 6000
50 799 39950
10 200 2000
5 310 1550
125 3778 64725

Seller_Name QTY Price Amount

Bharat Electronics 10 70 700
Tech Mart 12 40 480
Bharat Electronics 5 210 1050
Tech Mart 5 599 2995
Store 99 8 1250 10000
Bharat Electronics 20 300 6000
Tech Mart 50 799 39950
Store 100 10 200 2000
Bharat Electronics 5 310 1550

QTY Price Amount

QTY Price Amount
10 70 700
12 40 480
5 210 1050
5 599 2995
8 1250 10000
20 300 6000
50 799 39950
10 200 2000
5 310 1550

Mar Apr
76000 45000
5600 56000
45000 6700
3400 7800
130000 115500