Cov txheej txheem:

CP2 Excel Luj Qhov Nruab Nrab: 14 Kauj Ruam
CP2 Excel Luj Qhov Nruab Nrab: 14 Kauj Ruam

Video: CP2 Excel Luj Qhov Nruab Nrab: 14 Kauj Ruam

Video: CP2 Excel Luj Qhov Nruab Nrab: 14 Kauj Ruam
Video: How to write H2O and X2 in Excel? #subscript or #superscript in Excel- PART-2 | MUKUL JAIN 2024, Kaum ib hlis
Anonim
CP2 Excel Qhov hnyav nruab nrab
CP2 Excel Qhov hnyav nruab nrab

Cov lus qhia yuav ua li cas los xam qhov hnyav nruab nrab hauv Excel.

Hauv qhov piv txwv no SUMPRODUCT thiab SUM muaj nuj nqi yuav raug siv hauv Excel.

Qhov hnyav nruab nrab yog qhov muaj txiaj ntsig los laij cov qhab nia tag nrho rau chav kawm.

Khoom siv

Khoos phis tawj nrog Microsoft Excel

Kauj ruam 1: Sau daim ntawv Excel

Sau daim ntawv Excel
Sau daim ntawv Excel

Pib los ntawm thawj daim ntawv lo rau daim ntawv zoo.

Cov kab sab saum toj yog chav kawm, qib, thiab qhov hnyav

Thawj kab ntawv yog cov haujlwm tshwj xeeb hauv qhov no ob txoj haujlwm hauv tsev, ob daim ntawv xeem, ob txoj haujlwm, ob qhov kev xeem, thiab xeem zaum kawg.

Kauj Ruam 2: Nkag Mus Rau Qib Kawm thiab Qhov hnyav

Nkag Qib thiab Qhov hnyav
Nkag Qib thiab Qhov hnyav

Tam sim no koj tau sau daim ntawv excel koj tuaj yeem pib ntxiv koj qib kev ua haujlwm, thiab qhov hnyav ntawm txhua txoj haujlwm.

Kauj Ruam 3: Daim Ntawv Cim Npe

Daim Ntawv Ua Haujlwm
Daim Ntawv Ua Haujlwm

Ntxiv peb daim ntawv lo hauv qab koj cov ntaub ntawv uas tau nkag mus, peb lub cell yuav tsum tau sau ua SUMPRODUCT, SUM, thiab hnyav nruab nrab. Nov yog qhov kev suav suav yuav tshwm.

Kauj Ruam 4: Xam SUMPRODUCT

Xam SUMPRODUCT
Xam SUMPRODUCT

Txhawm rau xam SUMPRODUCT, xub xaiv lub xov tooj ntawm ib sab uas SUMPRODUCT tau ua haujlwm qhov no yog qhov kev suav yuav raug nthuav tawm. Tom qab koj tau xaiv lub xovtooj ntawm ib sab ntawm SUMPRODUCT daim ntawv lo, nyob rau hauv rooj plaub C12 no, nyem rau ntawm cov qauv tab nyob rau sab saum toj bar, tom qab ntawd nyem Math & Trig, nqes mus rau hauv cov ntawv qhia zaub mov kom txog thaum SUMPRODUCT tau tshwm thiab nyem rau nws.

Kauj ruam 5: SUMPRODUCT

SUMPRODUCT
SUMPRODUCT

Thaum xaiv SUMPRODUCT, lub luag haujlwm Kev sib cav qhov rai yuav qhib.

Kauj Ruam 6: SUMPRODUCT

SUMPRODUCT
SUMPRODUCT

Thawj kauj ruam los xam SUMPRODUCT yog xaiv cov qib kawm. Nyem rau Array1 lub npov, tom qab ntawd xaiv thawj qib hauv kab ntawv sau npe qib, thiab rub koj tus nas mus txog qib kawg hauv daim ntawv xaiv. Nws yuav tsum tshwm sim ua thawj lub cell sib cais los ntawm txoj hnyuv thiab lub cell kawg, hauv qhov piv txwv no nws yog B2: B10.

Kauj Ruam 7: SUMPRODUCT

SUMPRODUCT
SUMPRODUCT

Rau Array2 tib cov kauj ruam uas yuav tsum tau rov ua dua tshwj tsis yog xaiv qib, lub sijhawm no cov cell xaiv yog qhov hnyav. Pib los ntawm txhaj Array2 thiab xaiv thawj lub cell hauv qhov hnyav tom qab ntawd rub lub cell kom txog thaum kawg hnyav ntawm tes. Qhov no yuav raug nthuav tawm ua thawj lub cell nrog cov nyuv ces lub cell kawg nyob hauv qhov hnyav.

Array1 tau sau nrog tus "G" rau qib thiab Array1 tau sau nrog "W" rau qhov hnyav.

Tom qab ob leeg tau xaiv. Nyem "OK" kom ua tiav qhov kev suav.

Kauj Ruam 8: Teb

Teb
Teb

Cov txiaj ntsig ntawm SUMPRODUCT yuav tsum tau muab tso rau hauv lub xov tooj ntawm tes uas koj tau xaiv.

Kauj Ruam 9: Xam SUM

Xam SUM
Xam SUM

Tam sim no SUM xav tau los suav, zoo ib yam los suav SUMPRODUCT, xaiv cov qauv khawm nyob rau sab saum toj, tom qab ntawd Lej & Trig, tom qab ntawd nqes mus thiab nyem "SUM".

Kauj ruam 10: SUM

SUM
SUM

Tam sim no hais tias "SUM" tau raug xaiv, Qhov Kev Sib Tham Ua Haujlwm qhov rai tshwm tuaj. Txog Tus Zauv 1, lub cev hnyav yuav tsum tau xaiv, qhov no ua tiav tib txoj kev Array1 thiab Array2 rau SUMPRODUCt tau xaiv. Nyem thawj lub cell hauv qab qhov hnyav thiab rub nws kom txog rau thaum kawg hnyav ntawm tes. Thaum xaiv qhov hnyav, nyem "OK" kom ua tiav qhov suav.

Kauj ruam 11: Sum

Sum
Sum

Tom qab nyem "OK" qhov sib npaug ntawm qhov hnyav yuav raug nthuav tawm, yog tias cov ntaub ntawv raug nkag mus kom raug qhov suav yuav tsum sib npaug 100.

Kauj Ruam 12: Qhov hnyav nruab nrab

Qhov hnyav nruab nrab
Qhov hnyav nruab nrab

Txhawm rau suav qhov hnyav nruab nrab, SUMPRODUCT yuav tsum tau muab faib los ntawm SUM. Ua qhov nrig no nkag mus rau qhov kos npe sib npaug (=) rau hauv lub cell tom ntej ntawm qhov hnyav nruab nrab daim ntawv lo. Tom qab kos npe sib npaug tau nkag mus xaiv tus nqi SUMPRODUCT los ntawm txhaj rau nws.

Kauj ruam 13:

Duab
Duab

Thaum xaiv tus nqi SUMPRODUCT, nws yuav tsum tau muab faib los ntawm tus nqi SUM. Txhawm rau ua qhov no, xub ntaus ib qho tom ntej slash (/) tom qab ntawd xaiv tus nqi SUM. Thaum qhov no ua tiav, koj tuaj yeem nias nkag mus qhia qhov tshwm sim.

Kauj Ruam 14: Qhov hnyav nruab nrab

Qhov hnyav nruab nrab
Qhov hnyav nruab nrab

Thaum SUMPRODUCT tau muab faib los ntawm SUM, qhov hnyav nruab nrab yuav raug qhia.

Pom zoo: