2.2.02 函数公式-求和计数：SUMPRODUCT SUMIFS COUNTIFS 函数多条件求和或计数

东北黑龙江华北北京华北天津华北北京华北北京华北北京华北北京华北北京华北北京华北北京华北北京华北北京华北北京华北北京华北天津华北山东华北山东华北山东华北山东华北山东华北河北华北河北华北河北华北山西华北山西华北山西华北山东华北山东华北

山东

城市大连大连大连沈阳沈阳沈阳沈阳沈阳沈阳沈阳沈阳

齐齐哈尔北京天津北京北京北京北京北京北京北京北京北京北京北京天津济南烟台济南济南青岛秦皇岛石家庄唐山山西山西山西济南济南潍坊

性质店名自营AAAA-001自营AAAA-002自营AAAA-003自营AAAA-004自营AAAA-005自营AAAA-006自营AAAA-007自营AAAA-008自营AAAA-009自营AAAA-010自营AAAA-011加盟AAAA-012加盟AAAA-013加盟AAAA-014自营AAAA-015自营AAAA-016自营AAAA-017自营AAAA-018自营AAAA-019自营AAAA-020自营AAAA-021自营AAAA-022自营AAAA-023自营AAAA-024自营AAAA-025自营AAAA-026自营AAAA-027自营AAAA-028自营AAAA-029自营AAAA-030自营AAAA-031加盟AAAA-032加盟AAAA-033加盟AAAA-034加盟AAAA-035加盟AAAA-036加盟AAAA-037加盟AAAA-038加盟AAAA-039加盟

AAAA-040

华北山东华北山东华北河南华北河南华北河南华北河北华东福建华东福建华东福建华东福建华东福建华东福建华东福建华东福建华东福建华东福建华东福建华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东

上海

潍坊加盟淄博加盟河南加盟河南加盟开封加盟沧州加盟福州自营福州自营福州自营福州自营泉州自营泉州自营厦门自营厦门自营厦门自营厦门自营厦门自营南京自营南京自营苏州自营太仓自营芜湖自营宜兴自营常州自营镇江自营常熟自营常熟自营常州自营昆山自营南京自营南京自营南京自营南京自营苏州自营苏州自营无锡自营无锡自营无锡自营吴江自营无锡自营上海

自营

AAAA-041AAAA-042AAAA-043AAAA-044AAAA-045AAAA-046AAAA-047AAAA-048AAAA-049AAAA-050AAAA-051AAAA-052AAAA-053AAAA-0AAAA-055AAAA-056AAAA-057AAAA-058AAAA-059AAAA-060AAAA-061AAAA-062AAAA-063AAAA-0AAAA-065AAAA-066AAAA-067AAAA-068AAAA-069AAAA-070AAAA-071AAAA-072AAAA-073AAAA-074AAAA-075AAAA-076AAAA-077AAAA-078AAAA-079AAAA-080AAAA-081

华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东上海华东浙江华东浙江华东浙江华东浙江华东浙江华东浙江华东浙江华东浙江华东

安徽

上海上海上海上海郊县上海上海上海上海上海上海上海上海上海上海上海上海上海上海上海上海上海上海上海上海郊县上海郊县上海郊县上海郊县上海郊县上海郊县上海郊县上海上海富阳杭州杭州杭州杭州宁波宁波温州蚌埠

自营AAAA-082自营AAAA-083自营AAAA-084自营AAAA-085自营AAAA-086自营AAAA-087自营AAAA-095自营AAAA-096自营AAAA-097自营AAAA-098自营AAAA-099自营AAAA-100自营AAAA-101自营AAAA-102自营AAAA-103自营AAAA-104自营AAAA-105自营AAAA-106自营AAAA-107自营AAAA-108自营AAAA-109自营AAAA-110自营AAAA-111自营AAAA-112自营AAAA-113自营AAAA-114自营AAAA-115自营AAAA-116自营AAAA-117自营AAAA-118自营AAAA-119自营AAAA-120自营AAAA-121自营AAAA-122自营AAAA-123自营AAAA-124自营AAAA-125自营AAAA-126自营AAAA-127自营AAAA-128加盟

AAAA-129

华东安徽华东安徽华东安徽华东福建华东福建华东福建华东福建华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东江苏华东浙江华东浙江华东浙江华东浙江华东浙江华东浙江华东浙江华东浙江华东浙江华东江苏华东福建华南广东华南广东华南广东华南广东华南广东华南广东华南广东华南广东华南广东华南广东华南广东华南广东华南

广东

阜阳加盟合肥加盟合肥加盟福建加盟福建加盟福建加盟泉州加盟东台加盟淮安加盟江阴加盟连云港加盟南通加盟秦州加盟通州加盟无锡加盟无锡加盟丹阳加盟浙江加盟浙江加盟浙江加盟浙江加盟浙江加盟浙江加盟浙江加盟浙江加盟浙江加盟扬州加盟福州自营广州自营广州自营广州自营深圳自营深圳自营深圳自营深圳自营深圳自营深圳自营深圳自营东莞加盟东莞加盟汕头

加盟

AAAA-130AAAA-131AAAA-132AAAA-133AAAA-134AAAA-135AAAA-136AAAA-137AAAA-138AAAA-139AAAA-140AAAA-141AAAA-142AAAA-143AAAA-144AAAA-145AAAA-146AAAA-147AAAA-148AAAA-149AAAA-150AAAA-151AAAA-152AAAA-153AAAA-1AAAA-155AAAA-156AAAA-157AAAA-158AAAA-159AAAA-160AAAA-161AAAA-162AAAA-163AAAA-1AAAA-165AAAA-166AAAA-167AAAA-168AAAA-169AAAA-170

华南广东华南广东华南海南华南海南华南广东华中江西华中湖北华中湖北华中湖北华中湖北华中湖北华中湖南华中湖南西北陕西西北陕西西北陕西西北内蒙古西北内蒙古西北内蒙古西北陕西西北陕西西北甘肃西北陕西西南四川西南四川西南四川西南四川西南四川西南重庆西南重庆西南重庆西南重庆西南重庆西南贵州西南云南西南

重庆

深圳东莞海口海口佛山南昌武汉宜昌武汉武汉武汉长沙长沙西安西安西安包头呼和浩特呼和浩特宝鸡延安兰州西安成都成都成都成都成都重庆重庆重庆重庆重庆贵阳昆明重庆

加盟AAAA-171加盟AAAA-172加盟AAAA-173加盟AAAA-174加盟AAAA-175自营AAAA-176自营AAAA-177自营AAAA-178自营AAAA-183自营AAAA-184自营AAAA-185加盟AAAA-186加盟AAAA-187自营AAAA-188自营AAAA-1自营AAAA-194加盟AAAA-195加盟AAAA-196加盟AAAA-197加盟AAAA-198加盟AAAA-199加盟AAAA-200自营AAAA-201自营AAAA-205自营AAAA-206自营AAAA-207自营AAAA-208自营AAAA-209自营AAAA-210自营AAAA-212自营AAAA-213自营AAAA-214自营AAAA-215加盟AAAA-216加盟AAAA-217自营

AAAA-218

本月指标 150,000.00 280,000.00 190,000.00 90,000.00 270,000.00 180,000.00 280,000.00 340,000.00 150,000.00 220,000.00 120,000.00 350,000.00 260,000.00 320,000.00 200,000.00 100,000.00 330,000.00 250,000.00 170,000.00 160,000.00 150,000.00 400,000.00 260,000.00 300,000.00 110,000.00 340,000.00 280,000.00 130,000.00 320,000.00 240,000.00 330,000.00 240,000.00 250,000.00 140,000.00 210,000.00 90,000.00 90,000.00 160,000.00 110,000.00 310,000.00销售额 57,062.00 130,192.50 86,772.00 103,0.00 107,766.00 57,502.00 116,300.00 63,287.00 112,345.00 80,036.00 73,686.50 47,394.50 57,255.60 51,085.50 59,378.00 48,519.00 249,321.50 99,811.00 87,414.00 104,198.00 130,105.00 71,124.00 97,924.00 72,650.50 75,632.00 82,0.00 72,584.00 32,033.00 49,939.00 75,841.00 84,862.00 87,255.50 84,674.50 91,084.00 100,483.50 31,398.00 27,749.00 97,840.50 78,690.00 ,940.50销售成本 20,972.25 46,208.17 31,355.81 39,519.21 38,357.70 20,867.31 40,945.10 22,490.31 39,869.15 28,736.46 23,879.99 17,636.83 19,604.20 17,406.07 21,060.84 18,181.81 88,623.41 36,295.97 33,288.20 37,273.60 45,015.67 25,083.74 34,108.31 24,486.13 26,902.86 29,116.92 28,174.69 12,905.52 19,900.90 29,013.92 32,672.02 30,595.70 30,153.72 33,431.44 34,143.90 12,056.14 9,988.23 36,131.02 28,750.52 19,929.52

200,000.00 370,000.00 150,000.00 80,000.00 210,000.00 190,000.00 380,000.00 390,000.00 350,000.00 310,000.00 80,000.00 230,000.00 140,000.00 350,000.00 330,000.00 80,000.00 170,000.00 300,000.00 260,000.00 80,000.00 400,000.00 230,000.00 260,000.00 390,000.00 270,000.00 150,000.00 80,000.00 380,000.00 400,000.00 280,000.00 250,000.00 230,000.00 140,000.00 200,000.00 240,000.00 380,000.00 260,000.00 350,000.00 280,000.00 330,000.00 210,000.00 26,127.50 34,785.50 39,418.00 55,732.00 55,2.00 19,707.00 143,488.00 133,238.50 144,797.00 59,182.00 33,127.50 47,428.00 115,307.50 106,703.00 98,162.50 108,026.00 127,802.00 97,473.00 225,713.00 87,781.00 27,738.00 61,861.00 52,791.00 119,017.00 73,155.00 48,007.00 27,312.00 83,735.80 39,792.20 150,337.20 49,262.00 80,842.00 52,031.00 68,165.00 57,826.00 169,513.50 46,243.20 60,735.00 36,938.00 69,088.00 144,717.00 8,951.88 12,430.58 14,499.12 21,030.08 20,277.18 6,777.39 ,508.71 50,618.49 55,811.66 22,488.11 12,726.31 18,171.07 45,074.62 42,049.74 39,030.18 41,915.66 50,370.11 39,293.32 87,514.96 32,578.92 10,091. 22,0.60 20,683.86 49,072.13 28,003.74 19,209.82 10,499.07 32,020.30 16,006.37 56,259.38 19,088.07 30,566.43 19,665.57 31,946.86 20,432.87 ,451.36 18,718.74 21,733.05 14,144.45 22,770.55 53,529.84

370,000.00 110,000.00 130,000.00 270,000.00 260,000.00 210,000.00 120,000.00 100,000.00 160,000.00 340,000.00 320,000.00 280,000.00 350,000.00 260,000.00 230,000.00 330,000.00 380,000.00 90,000.00 110,000.00 170,000.00 230,000.00 130,000.00 90,000.00 270,000.00 270,000.00 210,000.00 190,000.00 380,000.00 400,000.00 310,000.00 270,000.00 90,000.00 150,000.00 130,000.00 80,000.00 190,000.00 190,000.00 190,000.00 170,000.00 270,000.00 100,000.00 143,178.00 ,120.00 72,720.00 134,295.00 1,230.00 185,887.00 147,275.20 161,420.00 88,067.00 153,762.00 91,776.50 44,582.00 196,922.00 132,376.00 267,968.00 ,749.00 184,037.00 138,033.00 107,421.00 102,873.00 279,503. 26,201.80 337,151.60 77,594.00 88,040.00 176,7.60 ,907.00 86,219.00 72,110.00 75,627.00 44,867.00 34,733.20 44,269.00 53,034.00 120,190.00 81,298.40 92,160.80 104,677.30 49,917.20 70,575.00 59,202.00 53,815.57 27,220.60 27,514.13 51,111.86 57,516.18 67,459.56 55,259.29 60,302.85 32,786.34 58,099.51 35,378.17 17,198.84 75,073.81 49,560.62 101,538.92 37,4.80 70,037.31 53,140.45 40,346.81 36,460.34 38,299.40 11,673.15 126,775.82 31,178.43 35,938. 67,626.74 33,495.39 34,388.27 27,751.11 29,372.07 13,393.43 10,761.82 16,708.48 20,393.67 45,913.90 31,574.59 35,284.06 39,713.93 19,047.13 26,597.65 20,915.93

270,000.00 90,000.00 300,000.00 330,000.00 210,000.00 100,000.00 160,000.00 390,000.00 380,000.00 230,000.00 70,000.00 230,000.00 240,000.00 260,000.00 380,000.00 190,000.00 300,000.00 400,000.00 110,000.00 380,000.00 290,000.00 190,000.00 180,000.00 250,000.00 270,000.00 330,000.00 380,000.00 100,000.00 120,000.00 230,000.00 250,000.00 110,000.00 150,000.00 320,000.00 350,000.00 210,000.00 80,000.00 90,000.00 170,000.00 150,000.00 350,000.00 46,661.00 101,737.00 60,415.50 31,012.00 59,495.50 51,182.50 66,526.00 30,857.00 76,487.00 92,477.00 63,523.00 68,748.50 67,939.00 41,735.00 85,948.00 79,5.00 ,622.00 41,125.00 25,843.00 43,769.50 47,785.00 ,112.00 56,516.50 41,391.00 13,902.20 47,192.00 60,476.50 41,917.00 52,785.10 83,692.00 42,910.40 55,218.50 95,128.00 84,445.00 71,967.00 46,948.50 78,171.00 44,010.50 73,297.50 86,530.00 102,682.00 17,428.09 36,708.13 22,461.99 11,155.84 21,511.63 18,011.23 24,139.33 11,341.85 26,350.97 31,745.84 22,6.33 24,883.33 24,401.79 14,033.92 31,323.68 28,975.01 19,434.14 15,340.69 9,296.13 15,671.04 17,446.09 18,325.69 20,681.82 15,302.06 4,851.37 17,161.16 22,306.30 14,076.55 21,237.42 33,788.84 18,086.36 23,788.94 35,791.34 30,587.81 27,414.23 17,717.88 29,210.03 17,014. 27,968.43 30,961.41 35,668.55

330,000.00 100,000.00 330,000.00 90,000.00 160,000.00 250,000.00 390,000.00 150,000.00 160,000.00 330,000.00 260,000.00 360,000.00 380,000.00 380,000.00 310,000.00 180,000.00 340,000.00 330,000.00 200,000.00 250,000.00 390,000.00 400,000.00 320,000.00 110,000.00 200,000.00 100,000.00 370,000.00 270,000.00 120,000.00 190,000.00 330,000.00 140,000.00 140,000.00 150,000.00 100,000.00 170,000.00 49,888.00 43,431.00 91,160.00 81,095.50 78,751.50 34,068.00 53,487.00 49,880.00 42,190.00 53,083.00 103,156.00 120,957.50 74,768.00 119,815.50 271,057.70 77,982.10 72,553.50 73,663.50 42,953.50 53,222.50 81,474.50 50,978.00 45,495.00 102,173.00 103,908.00 116,719.20 33,480.50 125,187.00 62,012.00 22,594.10 108,316.00 85,770.50 15,499.00 60,446.00 108,658.00 ,530.00 16,4.14 11,006.04 32,220.27 27,293.96 50,038.23 11,887.77 20,005.77 17,679.11 15,656.44 19,358.41 37,469.31 42,528.11 27,787.34 39,582.96 90,307.67 26,099.07 26,539.65 26,525.95 15,441.06 19,271.22 28,245.85 18,331.70 15,222. 37,869.18 40,502.56 45,129.10 9,013.31 45,5.87 22,574.10 9,914.22 38,732.25 31,126. 4,637.82 19,841.12 32,3.82 23,309.43