攝楍偲偼丄暋悢偺僙儖偺廤傑傝偱偡丅攝楍悢幃偲偼丄攝楍乮暋悢僙儖乯傪懳徾偵丄1偮偺悢幃傪嶌惉偡傞幃偱偡丅攝楍悢幃偱巊偆懳徾斖埻乮堷悢乯偼丄慡偰摨偠峴悢乛楍悢偱偁傞昁梫偑偁傝傑偡丅攝楍悢幃偼丄1偮侾偮偺僙儖傪懳徾偵寁嶼偡傞偟偐側偄 乮嶌嬈楍偑昁梫乯偲偄偭偨応崌偵妶桇偟傑偡丅

丂

仛拲両偁偊偰攝楍悢幃傪棙梡偟傑偡丅偙偙偱偛徯夘偡傞椺偱偼懠偵曋棙偱揔偟偰偄傞娭悢偑偁傝傑偡丅

椺丗崌寁嬥妟傪弌偡 =SUM(A2:A4*B2:B4)偲擖椡偟CTRL+SHIFT+Enter僉乕仺 {=SUM(A2:A4*B2:B4)}

仛 壙奿亊屄悢偺崌寁偑堦搙偵弌偣傑偡丅

丂

椺丗僠乕僘偺崌寁嬥妟傪C9偵弌偟傑偟傚偆乮A1乣A8偺奺僙儖偑僠乕僘偺応崌丄C1乣C8傪崌寁偡傞乯

丂

丂

仧 A楍偑僠乕僘側傜C楍偺壙奿傪崌寁偡傞偲偄偆攝楍悢幃傪嶌惉偡傞

亖SUM ( IF (A2:A8="僠乕僘" , C2:C8 , 0) )偲擖椡偟丄CTRL+SHIFT+ENTER傪墴 偡

{亖SUM ( IF (A2:A8="僠乕僘" , C2:C8 , 0) ) }

仸 攝楍悢幃埲奜偱偼SUMIF娭悢傗DSUM娭悢丄廤寁丄僼傿儖僞+SUBTOTAL娭悢傪巊偄傑偡丅SUMIF (A1:A8 , "僠乕僘" , C1:C8 ) DSUM ( A1:C8 , C1 , 忦審斖埻乯摍丅

丂

丂

攝楍悢幃偱暋悢忦審傪愝掕偡傞偙偲偼壜擻偱偡偑丄AND傗OR偼巊梡偱偒傑偣傫丅埲壓偺曽朄偱峴偄傑偡丅

丂

仧 AND娭悢乧乮忦審1乯*乮忦審2乯偺宍偱婰弎偡傞

仺 忦審傪乮 乯撪偵擖椡偟丄*偱楢寢偝偣傑偡丅

丂

仧 OR娭悢乧乮忦審1乯+乮忦審2乯偺宍偱婰弎偡傞

仺 忦審傪乮 乯撪偵擖椡偟丄+偱楢寢偝偣傑偡丅

丂

椺 丗彜昳偑乽僠乕僘乿偱揦曑偑乽廰扟乿偺傕偺傪崌寁偡傞

{ =SUM (IF (乮A2:A8="僠乕僘") *乮B2:B8="廰扟"乯, C2:C8 , 0 ))

仸 攝楍悢幃傪巊傢側偄応崌偼丄堦斒偵SUMIFS娭悢傗DSUM娭悢丄SUMPRODUCT娭悢丄SUBTOTAL娭悢傪巊偄傑偡丅仧 DSUM ( A1:C8 , C1 , 忦審斖埻乯 仧SUBTOTAL乮9 , C3:C7 )

娭楢丗攝楍悢幃偱暋悢忦審偱僇僂儞僩偡傞

丂

仭 攝楍悢幃偺僷僞乕儞

忦審傪巊偭偨攝楍悢幃偺婎杮僷僞乕儞偼 {=娭悢(IF(攝楍忦審,攝楍)}偱偡偺偱妎偊偰偍偔偲傛偄偱偟傚偆丅

椺丗=AVERAGE(IF(J2:J15="僠乕僘",K2:K15)) 

丂

仭 攝楍悢幃偱巊偊側偄娭悢

偳偺娭悢偱傕攝楍悢幃偱棙梡偱偒傞傢偗偱偼偁傝傑偣傫丅RANK娭悢傗COUNTIF娭悢丄SUMIF娭悢丄DSUM娭悢側偳偼巊偊傑偣傫丅

娭楢丗攝楍悢幃偱RANK娭悢傪巊偊傞丠