您好,讨教关于execl复合统计公式

hezi_19822022-10-04 11:39:541条回答

您好,讨教关于execl复合统计公式
有看过你回答类似问题,所以向你讨教,因为我写的公司一直出现错误.
=SUMPRODUCT((C:C=G1)*(A:A=F2)*D:D) A列为销售日期,c列为商品名称,D列为销售数量,E列为销售金额,我现在根据销售日期和商品名称统计指定商品在每天的销售量和销售额

已提交,审核后显示!提交回复

共1条回复
nidemaa 共回答了22个问题 | 采纳率100%
应该是出现了#VALUE!的错误提示了吧,这是因为公式用的整列的引用(EXCEL 2003版本更加是不支持整列引用),如A:A、C:C、D:D,这是包含了表头的销售日期、商品名称.等,SUMPRODUCT计算时是不能包含表头的,假设第一行为表头,则公式要避开第一行,即公式写作:
=SUMPRODUCT((C$2:C$2000=G1)*(A$2:A$2000=F2)*D$2:D$2000)
如果用的是EXCEL 2007及以上版本,则可以不必考虑表头的情况,公式精简为这样:
=SUMIFS(D:D,C:C,G1,A:A,F2)
1年前

相关推荐

您好:1.You can learn ( ) language.A.neither B.other C.either D
您好:
1.You can learn ( ) language.
A.neither B.other C.either D.another
2.His father will come back in ( ).
A.one and a half year B.a year and a half
C.a year and a half D.one years and a half
3.Who is ( ) man with glasses?
A.a B.an C.the D.
请说明其中的道理。
feifan041年前3
三木北谷 共回答了23个问题 | 采纳率82.6%
1C 2B OR C 3C
您好 They were towards the river.A.having B.forcing C.causing
您好 They were towards the river.A.having B.forcing C.causing D.magking 2.I didn写不下
1.they were_______towards the river.A.having B.causing C.forcing.D.making.
2.I didn't expect him to ________his thoughts.A.talk B.indicate C.reveal D.expose .
3.He does not_________his fellow workers and there are often different opinions between them .A.put up with B keep up with C.get along with D.go on with
这3道题在百度上有很多不同的答案,我实在搞不懂。请指教!
lh601年前2
爱上软肉帅哥 共回答了16个问题 | 采纳率93.8%
1.D 2.c 3.c
老师您好,关于词义辨析自己选择b
老师您好,关于词义辨析

自己选择b
ben20991年前1
zhang-jl 共回答了14个问题 | 采纳率85.7%
是的,选B. disagree
句意:你真幸运,因为你父母不反对你选择成为一个电脑游戏者.
dismiss, discourage, discover 都是及物动词,要跟宾语的.只有disagree 后接on,再接宾语.
您好,can i help you?yes,_.today is Mother day.i am looking for
您好,can i help you?yes,_.today is Mother day.i am looking for a present_my mother
,but _flowers shall i buy,roses or carnatins?i think carnatins are_.they mean happiness,sweetness and love.they are_mothers.how _are they?thirty yuan abunch.ok.i will_it.here is the money.thank you and best_to your mother.回答采纳重赏,
yandan031年前5
斑斑 共回答了10个问题 | 采纳率100%
can i help you?yes,please.today is Mother day.i am looking for a present for my mother ,but what kind of flowers shall i buy,roses or carnatins?i think carnatins are wonderful.they mean happiness,sweetness and love.they are befitting mothers.how much are they?thirty yuan abunch.ok.i will take it.here is the money.thank you and best wish to your mothe
英语独立主格问题With him leading,we set off early in the morning.您好!
英语独立主格问题
With him leading,we set off early in the morning.
您好!以上句子叫“独立主格”吗?理由?
wkp2171年前2
k37864 共回答了15个问题 | 采纳率86.7%
是的.
With him leading,------裏面的him是逻辑主语.整个结构做伴随状态,修饰时间 / 原因.
独立主格结构这个部分必须有自己的逻辑主语.你的可以变成这样的状语从句:
When / since he led the way,we set off early in the morning.
老师您好!Our friendship ____quickly over the weeks taht followed
老师您好!Our friendship ____quickly over the weeks taht followed.A.had developed B developed
选B 我想知道over一般和什么时态连用 ,不是一般都是现在完成时吗?
july_shi1年前1
粉红红粉 共回答了18个问题 | 采纳率88.9%
over后面接时段表示超过多少时间 一般用于完成时,但是也要结合句意来看.
您好!求助外语试题答案:谢谢!
左岸咖啡右岸茶1年前1
爱上你的泪2 共回答了16个问题 | 采纳率93.8%
1.With (A)_ three inches of rain falling in a six-month period,the farmers found it necessary to irrigate the landA.less thanB.little thanC.fewer thanD.less few than
2.One of the requirements for a fire is that the material _(B) to its burning temperature.A.be heatedB.is heatedC.would be heatedD.to heat
3.You _(B) the look on his face when he won the prize.A.would have seenB.should have seenC.must seeD.can be seeing
4.Her voice is _(A)A.loudB.aloudC.loudlyD.loudness
5.Only in recent years _(A)begun to realize that wild dogs,kept within bounds,often do more good than harm.A.people haveB.since people haveC.have peopleD.people who have
6.Fox was advised to give the assignment to _(A) he believed had a strong sense of responsibility.A.whomB.whomeverC.whoeverD.that
7.I have tried __(A)worrying about it.A.to stop consciouslyB.to consciously stopC.to conscious stoppingD.to stopping consciously
8.(A)that dress when I first saw you at the station?A.Were you wearingB.Have you wornC.Did you wearD.do you wear
9.Sound is conducted through steel in the same manner _(A).A.as in airB.as through airC.as air doesD.like air
10.If they _(C),our plan will fall flat.A.are co-operatingB.had not co-operatedC.won’t co-operateD.didn’t co-operate
11.“There she _(A)!We needn’t wait any longer.”A.comesB.has been comeC.has been comingD.is to come
12.“You realize that you were driving at 100 mph,don’t you?”“No,officer.I _(C).This car can’t do more than 80.”A.didn’t need to beB.may not have beenC.couldn’t have beenD.needn’t have been
13.There are nine of them,so _(C)get into the car at the same time.A.they may not at allB.all they may notC.they can’t allD.all they can’t
14.The highest temperature _(A) in any furnace on earth is about 10,000 centigrade.A.we can getB.that we can get itC.which we can get itD.what we can get
15.I‘m sure dirty,(A)?A.am IB.isn’t IC.aren’t ID.am not I
16.The insects would devour all our crops and kill our flocks and heads,if _(B) for the protection we get from insect-eating animals.A.it is notB.it were notC.were it notD.they were not
17.By no means _(A) their own language well.A.it is true that all English people knowB.is it true that do all English people knowC.it is true that do all English people knowD.is it true that all English people know
18.Everything on the earth _(A)all the time.A.is changingB.is changedC.has changedD.has been changed
19.The molecules of gases move more freely than _(B).A.do liquids and solidsB.liquids and solids doC.do those of liquids and solidsD.those do of liquids and solids
20.What beautiful weather,_(B)?A.is itB.isn’t itC.won’t itD.doesn’t it
先做一半,我拿几分呀?
英语翻译gu_feifei258,您好!I Spell the taobao site,I saw that you c
英语翻译
gu_feifei258,您好!
I Spell the taobao site,I saw that you can pay directly from there,"I did not know,
So enter your email:defaitane@yahoo.com.cn,the amount of 16.00,
I have to specify how to buy goods,I have to taobao?
You must immediately send the amount,you have warned me when the canvases are ready and I'll pay the?
I wish you a good day
ee阿浩1年前2
kameeer 共回答了25个问题 | 采纳率88%
我诅咒淘宝网.我看到了“你可以从那儿直接付款”,我不知道,所以输入了你的邮箱地址:defaitane@yahoo.com.cn,数量(或金额)是16.
我不得不弄清楚如何购物,我不得不去淘宝网?
你必须马上发数量(或金额)给我.你曾经提醒过我,当所有的油画都准备好了,我就可以付款
以上是字面的意思,但是有一些语义表达不是很清楚,你要联系你的实际来理解.
您好,As adults,male golden silk spiders live not in webs of th
您好,
As adults,male golden silk spiders live not in webs of their own making but rather in webs made by female spiders.
答案说这句话没有错误,可是为什么要说“live not”呢?我觉得应该改为“don't live”?
4.At a time when interest in twentieth-century classical music seems on the verge "to aisappear",the avantgarde compositions of the 1960s and 1970s manage to retain their popularity.
答案说“to disappear”错误,该怎么改呢?改为“disappearing”吗?为什么呢?还有“compositions”不是指物吗,为什么不把“manage”改为“are managed”被动形式呢?
5.Annual visitors to New York City's Central Park number almost ten times that of Mount Rushmore.
答案说这句话正确,可为什么不说“that to Mount Rushmore”呢?这样可以构成平行结构.
6.To insisit that a poem means whatever one wants it to mean is often ignoring the intention and even the words of the poet.
答案是“ignoring”错误,是不是应该改为“to ignore”呢?
期待回复!
hanfeng10211年前2
luck2b99 共回答了16个问题 | 采纳率93.8%
1.这里not...but..是强调他们不住在自己的web里(强调的是地点而不是动词live),并没有语法错误,你改成don't live的话前半句意思还一样,后半句就不对了,除非再把后半句改成一句话but they rather live in...但是那样不是很繁琐吗?
2.on the verge of...固定搭配,不能用to disappear,固定搭配神马的最后几道经常出现,可以去背,至于manage to为什么要被动?作品设法保持了popularity我觉得没有错,从来没有见过are managed to.主语就是作品吧,不是人,那就不需要被动.
3.这里that指代annual visitors,of表示从属关系,不是看平行,你要说annual visitors to mount rushmore也是对的,但是这句话没错而且简洁.
4.对的,to do sth is to do sth,经常考的结构
我觉得你的问题不是多做题可以解决的,很多用法都是常见的,最好加大英文阅读量,如果没时间可以去上课,老师会总结语法常考的点.其实大部分人都是这样的,我也在学习中,大家共同进步吧.祝你sat考得好~
英语名子结构分析.大哥/大姐:您好!Credit cards,as a means of payment,have be
英语名子结构分析.
大哥/大姐:您好!
Credit cards,as a means of payment,have become more and more popular in our daily life.
这句话的"credit cards" 我可不可以在前面不加冠词-"a,the",又不以复数形式表现,而直接用"credit card"来作主语?
zmwbdlq1年前3
wqw111 共回答了17个问题 | 采纳率88.2%
不可以,你要么说the/a credit card,要么说credit cards,表示概念的时候只能这么用.
英语翻译 您好.叔叔2. &
英语翻译
您好.叔叔
2.5岁了.我上XX幼儿园.今天画树了.(5岁今天画画了 画了个树)
3.我想吃冰淇淋.
4.不我想吃汉堡.
5.是~妈妈切给我这边的.(自足餐中小孩想要吃的太大所以想要的部位切一块)
6.妈我会有弟弟?(扮演妈的怀孕几月亲戚对话中大概了解所以提问)
7.过一会唱歌.(预定想要唱儿童哥)
8.但是太甜.(吃的食物)
9.爸爸我有点困了~(该回家了)
不要在线翻译的.不踏实
场景是一大家族进餐店后各自介绍点菜类型的ABC人对话
我负责5岁小孩对话.后面()里面场景和环境描述不用翻译.
ever20011年前1
jiaxiaoyong52042 共回答了22个问题 | 采纳率86.4%
1.Hello,uncle,how are you?
2.I'm 5 years old,going to XX kindergarten.Today,I paint a tree.(5 years old,paint a picture of a tree today)
3.I want some ice cream.
4.I do not want to eat hamburgers.
5.Yes !Mom I want this side.(At a buffet,the child wants a piece that is too large for him or her.Mom cuts it up.The child demands a particular side of the piece.)
6.Mom,am I going to have a brother?(The actress playing the Mom appears to be pregnant.This is a common question asked by a child.)
7.Do the singing a bit later.(Scheduled to sing children's song)
8.But it's too sweet.(Refers to food)
9.Dad I'm a bit sleepy !(It's time to go home!)