Bai Giai Sheet TK1 On1_On Mot So Ham 1

Bai Giai Sheet TK1 On1_On Mot So Ham 1 - Hng SX M hng Ngy...

Info icon This preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Hãng SX Mã hàng Ngày nhập Sô lượng Khuyến mãi 1 Khuyến mãi 2 SO 05/01/2012 650 SA 06/05/2012 100 TO 07/04/2012 90 TO 04/08/2012 250 SA 07/07/2012 600 TO 09/07/2012 55 SO 25/08/2012 290 SA 28/09/2012 450 SO 30/09/2012 70 TO 24/09/2012 6 SA 21/10/2012 60 TO 26/11/2012 170 SA 25/11/2012 450 SO 20/12/2012 95 Mô tả: Số lượng là các ký tự số của cột Mã hàng Tên hàng và hãng SX TV _ 650 TV _ 100 DM _ 90 LO _ 250 TV _600 DM _55 LO _290 LO _450 DM _70 TV _6 LO _60 TV _170 DM _450 DM _95
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Khuyến mãi 3 Khuyến mãi 4 400000 1 5 4 8 400000 7 7 8 400000 9 9 9 10 11 400000 11 12 Khuyến mãi 5 Khuyến mãi 6 Khuyến mãi 7
Image of page 2
1 1 0 0 1 1 0 1 1 1 0 1 1 0
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
TK B NG NH N XÉT H C T P Mã HV H tên Đi m Đi m TC X p Lo i ế X p h ng ế A01 Le A 5 B01 Bui C 3.5 C02 Tran Y 7.5 A05 Do G 8 B03 Truong L 6.5 A07 Tran D 3 A05 Phan A 9.5 B04 Bui K 8.5 A04 Pham A 5.5 B08 Ly B 2 C10 Tran Y 8 T ng s h c viên Đi m TC cao nh t Đi m TC th p nh t S h c viên có x p lo i Khá ế S h c viên có x p lo i Kém ế
Image of page 4
DÙNG STT 1 2 3 4 5 6 7 8 9 THỐNG KÊ 1 MẶT HÀNH TỔNG SỐ MẶT HÀNG TỔNG SỐ LƯỢNG A001 =COUNTIF($D$3:$D$11,A15) =SUMIF($D$3:$D$11,A15,$E$3:$E$11 B001 1 150 D003 2 1000 C002 1 200 KÝ TỰ ĐẦU MÃ MH A B C D
Image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
G HÀM COUNTIF VÀ SUMIF ĐỂ THỐNG KÊ MẶT HÀNH A001 A002 A001 B001 B002 C001 C002 D003 D003 1) THỐNG KÊ 3 (THEO SỐ LƯỢNG) THÁNG 1 =SUMIFS($E$3:$E$11,$D$3:$D$11,$C23&"*",$F$3:$F$11,D$22) 0 0 0
Image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern