Yog tias koj sau cov qauv kom raug thiab thaum koj hloov kho daim ntawv, SUMIF muaj nuj nqi tsis rov qab tus nqi tshiab. Nws yog qhov ua tau tias koj tau teeb tsa cov lej suav rau phau ntawv. Nias F9 tus yuam sij txhawm rau txheeb xyuas daim ntawv. Txheeb xyuas cov qauv ntawm qhov muaj nuj nqis koom nrog hauv kev suav.
Vim li cas Excel tsis ua haujlwm?
Yuav ua li cas 1: Cells yog formatted raws li ntawv nyeem Ua rau: Lub cell yog formatted li ntawv, uas ua rau Excel tsis quav ntsej tej qauv. Qhov no tuaj yeem yog ncaj qha los ntawm Cov Ntawv Teev Npe, lossis tshwj xeeb tshaj yog thaum xa cov ntaub ntawv los ntawm CSV lossis Notepad cov ntaub ntawv. Kho: Hloov hom ntawv ntawm tes mus rau General lossis lwm hom ntawv.
Kuv yuav tau Sumif ua haujlwm li cas?
Yog tias koj xav tau, koj tuaj yeem siv cov txheej txheem rau ib qho thiab suav nrog cov txiaj ntsig sib txawv. Piv txwv li, tus qauv =SUMIF(B2:B5, "John", C2:C5) tsuas yog cov txiaj ntsig hauv thaj tsam C2: C5, qhov twg cov hlwb sib txuas hauv thaj tsam B2: B5 sib npaug "John. "
Vim li cas kuv Sumif qhia 0?
Re: SUMIF muaj nuj nqi qhia xoom raws li qhov tshwm sim
Zoo koj yuav muaj qhov sib nrug ntawm pem hauv ntej / tom qab cov ntawv nkaguas yuav tsis phim qhov kev tshawb nrhiav.
Kuv yuav kho qhov yuam kev Sumif hauv Excel li cas?
Yuav daws qhov yuam kev, xaiv ib lub xovtooj ntawm cov khoom txeej kom koj tuaj yeem pom nws cov ciam teb Tom qab ntawd txav cov ntaub ntawv thaiv mus rau qhov chaw tshiab, lossis tshem tawm cov ntaub ntawv tag nrho. Nco ntsoov tias cov hlwb hauv qhov nchuav yuav tsum yog khoob, yog li ua tib zoo mloog cov hlwb uas muaj cov cim tsis pom, zoo li qhov chaw.
