Scribd
Upload
6 views6 pages

Sample Data File

The document contains a table of student marks and total marks for three students, along with a sales report for various products categorized under Furniture, Office Supplies, and Technology. It includes sales figures, profit, and flags indicating certain conditions for each product. Additionally, there are references to Excel functions for calculating total sales based on specific criteria.

Uploaded by

imtiyaz
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
6 views6 pages

Sample Data File

The document contains a table of student marks and total marks for three students, along with a sales report for various products categorized under Furniture, Office Supplies, and Technology. It includes sales figures, profit, and flags indicating certain conditions for each product. Additionally, there are references to Excel functions for calculating total sales based on specific criteria.

Uploaded by

imtiyaz
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/ 6

Column

Rows

Cell

S.No. Student ID Marks Total Marks


1 21 100
2 32 200
3 34 100
tell me?
1234
S.No. Student ID Marks Total Marks
1 21 100 400 400
2 32 200 400
3 34 100 400
400
400
400
Categories Product ID Sales Profit Flag Flag
Furniture 1 9 58 1 FALSE
Furniture 2 38 52 1 TRUE
Furniture 2 65 8 0 TRUE
Office Supplies 8 20 30 0 FALSE
Office Supplies 9 78 84 1 TRUE
Technology 14 32 10 1 TRUE
Technology 15 94 51 1 TRUE
Technology 16 33 1 1 TRUE
Office Supplies 6 4 4 1 FALSE
Office Supplies 7 64 56 1 TRUE
Furniture 2 71 8 1 TRUE
Furniture 5 53 65 0 TRUE
Office Supplies 10 45 60 1 TRUE
Technology 11 59 20 1 TRUE
Technology 12 25 31 1 FALSE
Technology 13 70 65 0 TRUE
Hw
Furniture Technology
Total Sales
Expected Output
Total sales where product id = 2 and category = furniture

sumif countif averageif


sumifs countifs averageifs

You might also like