[go: up one dir, main page]
Scribd
Upload
28 views2 pages

Lecture 08

The document contains sales data from various dates in January and February 2019 including the sales representative, brand, sales amount, cost of goods sold (COGS), and location. There is a total of 62 rows of sales data recorded over this time period for different brands like Nike, Adidas, Calvin, Tommy, and Kawasaki across various locations in Bangladesh.

Uploaded by

imran.sbmc534
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
28 views2 pages

Lecture 08

The document contains sales data from various dates in January and February 2019 including the sales representative, brand, sales amount, cost of goods sold (COGS), and location. There is a total of 62 rows of sales data recorded over this time period for different brands like Nike, Adidas, Calvin, Tommy, and Kawasaki across various locations in Bangladesh.

Uploaded by

imran.sbmc534
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Basic IF

Total Sales Total COGS

Date Sales Rep Brand Sales COGS Location


1/2/2019 Hossain Kawasaki 1620 720 Bashundhara
1/3/2019 Shimul Nike 2015 1500 Nadda
1/4/2019 Saiful Nike 2360 2100 Badda
1/5/2019 Kabir Tommy 2600 2500 Mirpur
1/6/2019 Nik Nike 2569 2400 Mirpur
1/7/2019 Kalam Adidas 1650 1150 New Market
1/8/2019 Nik Calvin 5600 4580 Mirpur
1/9/2019 Hossain Calvin 2650 2140 Shyamoli
1/10/2019 Nik Kawasaki 2689 2590 Old Dhaka
1/11/2019 Hossain Kawasaki 2300 2140 Uttara
1/12/2019 Nik Calvin 5600 4580 Mirpur
1/13/2019 Hossain Calvin 2650 2140 Nadda
1/14/2019 Nik Kawasaki 2689 2590 Badda
1/15/2019 Hossain Kawasaki 2300 2140 Mirpur
1/16/2019 Hossain Kawasaki 1620 720 Malibagh
1/17/2019 Shimul Nike 2015 1500 New Market
1/18/2019 Saiful Nike 2360 2100 Dhanmondi
1/19/2019 Kabir Tommy 2600 2500 Shyamoli
1/20/2019 Nik Nike 2569 2400 Old Dhaka
1/21/2019 Kalam Adidas 1650 1150 Uttara
1/22/2019 Kabir Tommy 2600 2500 Mirpur
1/23/2019 Nik Nike 2569 2400 Malibagh
1/24/2019 Kalam Adidas 1650 1150 New Market
1/25/2019 Nik Calvin 5600 4580 Dhanmondi
1/26/2019 Hossain Calvin 2650 2140 Shyamoli
1/27/2019 Nik Kawasaki 2689 2590 Old Dhaka
1/28/2019 Hossain Kawasaki 2300 2140 Uttara
1/29/2019 Nik Calvin 5600 4580 Bashundhara
1/30/2019 Hossain Calvin 2650 2140 Nadda
1/31/2019 Nik Kawasaki 2689 2590 Badda
2/1/2019 Hossain Kawasaki 2300 2140 Mirpur
2/2/2019 Hossain Kawasaki 1620 720 Malibagh
2/3/2019 Shimul Nike 2015 1500 New Market
Sumif
Countif
Averageif

Sumifs
Countifs
Averageifs
Maxifs
Minifs

You might also like