求高手解答：excel中求一组数据中的奇偶比公式。。。 求助高手，excel中怎样用公式算012路和奇偶的个数，如图...
EXCEL\u4e2d\u600e\u6837\u7528\u516c\u5f0f\u7edf\u8ba1\u4e00\u7ec4\u6570\u5b57\u7684\u5947\u5076\u6bd4,\u5982\u56feC1\u4e0b\u62c9
=COUNT(FIND({1,3,5,7,9},A1))&":"&COUNT(FIND({0,2,4,6,8},A1))
\u5148\u7ed9\u4f60\u7684\u5947\u5076\u516c\u5f0f\u5427\uff1a
C2\u8f93\u5165
=COUNT(FIND({"1","3","5","7","9"},A2))&COUNT(FIND({"2","4","6","8","0"},A2))
\u56de\u8f66\u5e76\u5411\u4e0b\u586b\u5145\u3002
计算(奇数个数/偶数个数)：=SUM((MOD(A2:F2,2)<>0)*1)/SUM((MOD(A2:F2,2)=0)*1) 数组公式
奇数占比：=SUM((MOD(A2:F2,2)<>0)*1)/COUNT(A2:F2) 数组公式
H2单元格写入公式
=SUMPRODUCT(MOD(A2:F2,2))&"/"&SUMPRODUCT(--(MOD(A2:F2,2)=0))
下拉复制公式
得出的值为 奇数个数/偶数个数 这样的形式
是要这样的公式吗
=sum(mod(A2:F2,2))&":"&sum(mod(A2:F2+1,2))
绛旓細=SUMPRODUCT(MOD(A2:F2,2))&"/"&SUMPRODUCT(--(MOD(A2:F2,2)=0))涓嬫媺澶嶅埗鍏紡 寰楀嚭鐨勫间负 濂囨暟涓暟/鍋舵暟涓暟 杩欐牱鐨勫舰寮 鏄杩欐牱鐨勫叕寮忓悧
绛旓細璁＄畻(濂囨暟涓暟/鍋舵暟涓暟)锛=SUM((MOD(A2:F2,2)<>0)*1)/SUM((MOD(A2:F2,2)=0)*1) 鏁扮粍鍏紡 濂囨暟鍗犳瘮锛=SUM((MOD(A2:F2,2)<>0)*1)/COUNT(A2:F2) 鏁扮粍鍏紡
绛旓細璁＄畻1鐨勪釜鏁扳斺 =SUM(IF({1,3,4,9,12,15,4,3,9}=,1,0))璁＄畻4鐨勪釜鏁扳斺 =SUM(IF({1,3,4,9,12,15,4,3,9}=,4,0))濡傛灉鏄帓鍒楀湪涓鍒楀亣濡侫鍒楃殑涓缁鏁版嵁锛屽垯鍙互濡備笅璁剧疆锛氬伐浣滆〃涓紝A鍒楁槸涓缁勬暟鎹紝C2閿叆鐨勬槸瑕佽绠椾釜鏁扮殑鏁板瓧锛孌2閿叆鍏紡锛=COUNTIF(A:A,C2)璇存槑锛氬彧...
绛旓細N4杈撳叆鍏紡 =IF(AND(H3=H$1,I3=I$1,J3=J$1),"婊¤冻鏉′欢","")涓璧蜂笅鎷夊嵆鍙
绛旓細acell.Value = Val(acell.Value * 0.6)End If Next End Sub 灏嗕笂闈㈢殑绋嬪簭鎶勫埌浣犵殑vba缂栬緫鍣閲锛岃繍琛屻傚叾涓紝sheet1鏄伐浣滆〃鐨勫悕绉帮紝濡傛灉浣犵殑宸ヤ綔琛ㄦ湁鍒殑鍚嶇О锛岃鎸夊疄闄呮儏鍐典慨鏀广備笉濂芥剰鎬濓紝鍋瑙ｇ瓟鐨勬椂鍊欐病鐪嬪埌浜屾ゼ鐨勮В绛旓紝閭ｄ釜鍔炴硶浼间箮鏇村ソ銆備絾濡傛灉鏈変簺鍗曞厓鏍煎師鏉ユ槸绌虹櫧鐨勮瘽锛屼細浜х敓涓涓0锛...
绛旓細vlookup鍑芥暟鐨勭敤娉曚綘鍙互鐧惧害涓 ,鍥犱负vlookup閫氬父鐨勫仛娉曟槸鏍规嵁鍗曞垪杩涜鏌ユ壘,杩欓噷鏄袱鍒,鎵浠ュ厛瑕佺敤IF({1,0},$A$4:$A$14&$B$4:$B$14,$C$4:$C$14)璐缓涓涓唴瀛樻暟缁,鍦ㄥ唴瀛樹腑鎶$A$4:$A$14&$B$4:$B$14鍚堝苟鎴愪竴鍒 鎴栬呯敤SUMPRODUCT鍑芥暟涔熻兘瀹炵幇浣犵殑瑕佹眰,G4鍗曞厓鏍艰緭鍏=SUMPRODUCT((...
绛旓細C1 鍏紡:=IF(NOT(AND(ISERROR(FIND({0,1,2},A1))),IF(NOT(AND(ISERROR(FIND({3,4,5,6},A1))),IF((AND(ISERROR(FIND({7,8,9},A1))),"灏忎腑",""),""),"")D1 鍏紡:=IF(NOT(AND(ISERROR(FIND({0,1,2},A1))),IF(NOT(AND(ISERROR(FIND({3,4,5,6},A1))),IF(NOT...
绛旓細鍦ㄧ┖鐧藉崟鍏冩牸杈撳叆锛=7/6锛岀劧鍚庡鍒惰鍗曞厓鏍硷紝閫夋嫨闇瑕佷箻鐨勬暟鎹寖鍥达紝鍙抽敭鈥斺旈夋嫨鎬х矘璐粹斺旇繍绠楀閫夆滀箻鈥濓紝灏監K浜嗐 鑻ラ渶瑕佹敼涓哄垎鏁版牸寮忥紝閫夋嫨鍗曞厓鏍煎彸閿斺斿崟鍏冩牸鏍煎紡鈥斺斿父瑙勨斺旈夋嫨鍒嗘暟銆
绛旓細Sub LKJLJ()Dim I&, x For I = 2 To [A65536].End(3).Row aa = Split(Cells(I, 1), Chr(10))bb = Split(aa(0), "銆")cc = Split(aa(1), "銆")For x = 0 To 4 If bb(x) > 100 Then kk = kk + 1 If cc(x) > 100 Then kk = kk + 1 Next Cells(I, 2...
绛旓細1銆侀鍏鍦╡xcel琛ㄦ牸涓緭鍏涓缁鏁版嵁锛岄渶瑕佸皢杈撳叆鐨勬暟鎹繘琛屾眰骞冲潎鏁版搷浣溿2銆佸湪绌虹櫧鍗曞厓鏍间腑杈撳叆=Average(A2:C2鍚庣揣鎺ョ潃杈撳叆涓涓楀彿銆3銆佺劧鍚庡啀缁х画閫変腑鍙﹀涓涓崟鍏冩牸鍖哄煙锛岃繖鏍峰氨褰㈡垚涓嬪浘鐨勫叕寮 锛=AVERAGE(A1:C2,B1:B10)銆4銆佺偣鍑诲洖杞﹀嵆鍙敓鎴愯绠楃粨鏋滐紝鍙互鐪嬪埌姝ゆ椂鍙互灏嗛変腑鍖哄煙鐨勫钩鍧囨暟姹傚嚭銆
