Syntaxe de Sommeprod ?

Bonjour � tous.

Je sais qu'il existe, terr� dans ce MPFE sous des apparences respectables, 
une chapelle des adepte de SOMMEPROD.

Une recherche dans l'aide de Excel ne m'a pas apport� la Lumi�re.

Si l'un des gourous de cette secte s'�tait d�j� remis des agapes de cette 
nuit, je lui serais reconnaissant de bien vouloir m'expliquer les -- dans 
cette formule :

=SUMPRODUCT(--(B5:B1953=101),--(C5:C1953=7)*(D5:D1953))

En toute amiti�,

Patrick.

Ps : Aucun caract�re d'urgence, c'est simplement pour accro�tre mes 
connaissances.



0
1/1/2005 10:33:27 AM
excel 39879 articles. 2 followers. Follow

3 Replies
896 Views

Similar Articles

[PageSpeed] 15

Sorry for the mistake.
I wanted to post on the french NG.

Meanwhile, Happy New Year to you all.

Patrick.


> Bonjour � tous.
>
> Je sais qu'il existe, terr� dans ce MPFE sous des apparences
> respectables, une chapelle des adepte de SOMMEPROD.
>
> Une recherche dans l'aide de Excel ne m'a pas apport� la Lumi�re.
>
> Si l'un des gourous de cette secte s'�tait d�j� remis des agapes de
> cette nuit, je lui serais reconnaissant de bien vouloir m'expliquer
> les -- dans cette formule :
>
> =SUMPRODUCT(--(B5:B1953=101),--(C5:C1953=7)*(D5:D1953))
>
> En toute amiti�,
>
> Patrick.
>
> Ps : Aucun caract�re d'urgence, c'est simplement pour accro�tre mes
> connaissances. 


0
1/1/2005 10:53:28 AM
Hi Patrick
maybe the following helps you anyway :-)
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

-- 
Regards
Frank Kabel
Frankfurt, Germany
"Patrick BASTARD" <pasdespambastardp@freepasdespam.fr> schrieb im 
Newsbeitrag news:%23RtfdA$7EHA.3124@TK2MSFTNGP11.phx.gbl...
> Sorry for the mistake.
> I wanted to post on the french NG.
>
> Meanwhile, Happy New Year to you all.
>
> Patrick.
>
>
>> Bonjour � tous.
>>
>> Je sais qu'il existe, terr� dans ce MPFE sous des apparences
>> respectables, une chapelle des adepte de SOMMEPROD.
>>
>> Une recherche dans l'aide de Excel ne m'a pas apport� la Lumi�re.
>>
>> Si l'un des gourous de cette secte s'�tait d�j� remis des agapes de
>> cette nuit, je lui serais reconnaissant de bien vouloir m'expliquer
>> les -- dans cette formule :
>>
>> =SUMPRODUCT(--(B5:B1953=101),--(C5:C1953=7)*(D5:D1953))
>>
>> En toute amiti�,
>>
>> Patrick.
>>
>> Ps : Aucun caract�re d'urgence, c'est simplement pour accro�tre mes
>> connaissances.
>
> 


0
frank.kabel (11126)
1/1/2005 11:15:33 AM
Hi, Frank.


I got the answer : -- translate Yes/no to 1/0.

I wish you a happy new year.

Best regards


-- 
P. Bastard






> Hi Patrick
> maybe the following helps you anyway :-)
> http://www.xldynamic.com/source/xld.SUMPRODUCT.html
>
>> Sorry for the mistake.
>> I wanted to post on the french NG.
>>
>> Meanwhile, Happy New Year to you all.
>>
>> Patrick.
>>
>>
>>> Bonjour � tous.
>>>
>>> Je sais qu'il existe, terr� dans ce MPFE sous des apparences
>>> respectables, une chapelle des adepte de SOMMEPROD.
>>>
>>> Une recherche dans l'aide de Excel ne m'a pas apport� la Lumi�re.
>>>
>>> Si l'un des gourous de cette secte s'�tait d�j� remis des agapes de
>>> cette nuit, je lui serais reconnaissant de bien vouloir m'expliquer
>>> les -- dans cette formule :
>>>
>>> =SUMPRODUCT(--(B5:B1953=101),--(C5:C1953=7)*(D5:D1953))
>>>
>>> En toute amiti�,
>>>
>>> Patrick.
>>>
>>> Ps : Aucun caract�re d'urgence, c'est simplement pour accro�tre mes
>>> connaissances. 


0
1/1/2005 12:24:47 PM
Reply:

Similar Artilces:

Plans de plans dans les feuilles de calcul
Bonjour, Je tente de cr�er des plans � l'int�rieur de feuilles � plusieurs colonnes & lignes incluant des sous totaux (C'est un suivi budg�taire avec des sommations � tous les sept jours avec un cum du mois � la derni�re colonne ). A l'extrimit� gauche des feuilles le symbole masquer " - " apparait. Mais lorsque je click sur ce symbole afin d'obtenir un plan avec le symbole " + " Excel m'affiche le message suivant:"CANNOT SHIFT OBJECTS OFF SHEET". Quelle serait la raison qui fait en sorte qu'Excel ne peut cr�er un plan en dissimulan...

Syntax Error
I have just bought a Lexmark Pro 700 Series Printer but I have received the following error message Line 53 Char 1 Error Syntax Error Code 0 URL file://C:/Documents%20Settings/User//Local%20Settings/Temp/DSX20.tmp I have been told it is something to do with my Internet browser settings has anyone any ideas ? -- edr Always state your full Windows version (e.g., WinXP SP3; WinXP 64-bit SP2; Vista SP1; Vista 64-bit SP2; Win7; Win7 64-bit) as well as your IE version when posting in an IE-specific forum or newsgroup. Please do so in your next reply. Assuming Vista...

Conditional formating syntax help...
HI All, A simple one I know but I'm perplexed... I would like to have the ability ot enter a number on a spreadsheet and then LOOKUP that number on a sperate worksheet and if it is there for the entered number to change colours, Green in this case. If the number is NOT on the second worksheet, I wouls like it to turn display in RED. Thanks in advance G.. One way: Name your lookup range in the second sheet, say, LookupRange. Then in Sheet1 enter this (say cell A1 is active): CF1: Formula is =AND(A1<>"",ISNA(MATCH(A1,LookupRange,FALSE))) Format1: <font&g...

Syntaxe de Sommeprod ?
Bonjour � tous. Je sais qu'il existe, terr� dans ce MPFE sous des apparences respectables, une chapelle des adepte de SOMMEPROD. Une recherche dans l'aide de Excel ne m'a pas apport� la Lumi�re. Si l'un des gourous de cette secte s'�tait d�j� remis des agapes de cette nuit, je lui serais reconnaissant de bien vouloir m'expliquer les -- dans cette formule : =SUMPRODUCT(--(B5:B1953=101),--(C5:C1953=7)*(D5:D1953)) En toute amiti�, Patrick. Ps : Aucun caract�re d'urgence, c'est simplement pour accro�tre mes connaissances. Sorry for the mistake. I want...

A syntax question
Hi to all, How can I write a member function to return a two-dimensional array of BYTE? - The data member definition of my array is as follows: private: BYTE m_array[7][12] - The member function definition is: BYTE *&CMyClass::GetArray() { return m_array; } I appreciate any help. Thank you. Geo Hi, typedef BYTE ARR_TYPE [7][12]; class CMyClass { ARR_TYPE m_array; public: ARR_TYPE &GetArray() { return m_array; } }; CMyClass mc; ARR_TYPE &arr = mc.GetArray(); int j = arr[0][10]; // You can use pointers instead of references. -- ====== Arm...

OR syntax
I want to insert 1 in a cell if the value in another cell matches one or more of 5 other cells. I have tried =IF(OR(C20=C5,D5,E5,F5,G5),1,"-") but does not seem to work. Is this syntax is incorrect? May be there is a better way to do this? Your help will be much appreciated. Try it this way: =3DIF(OR(C20=3DC5,C20=3DD5,C20=3DE5,C20=3DF5,C20=3DG5),1,"-") Hope this helps. Pete On Jan 14, 4:00=A0pm, "Dave" <dave@dave> wrote: > I want to insert 1 in a cell if the value in another cell matches one or > more of 5 other cells. =A0I have tried =...

etude de cas
ce n'est qu'un essai "magali granier" <mag.nier@infonie.fr>, iletisinde sunu yazdi, news:eCTVPO1WIHA.5340@TK2MSFTNGP06.phx.gbl... > ce n'est qu'un essai > ...

Syntax
What is the correct syntax of the Excel formula for this expression: If A1="DOG" or if B1="CAT" or if C1="POSSUM" or if D1="FERRET" then "YES" else "NO". =IF(OR(A1="Cat",B1="Dog",C1="Possum",D1="Ferret"),"Yes","No") -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "gary" <anonymous@discussions.microsoft.com> wrote in message news:2db201c45c46$8e0b7c40$3a01280a@phx.gbl... > ...

Proper Syntax Required
My form is populated by a query. In the query there are two calculated fields -- NetCost and NeNetCost. The following IIF's are in text boxes. The first one with the string responses works as expected so the logic seems to be okay but I keep getting #Name? error in the text box of the second one. Could someone please explain what my issue is. Thanks =IIf(IsNull([NewNetCost]),("It is Null"),("HasValue")) ****** This is just a test scenario ******* =IIf(IsNull([NewNetCost]),[NetCost],[NewNetCost]) On Thu, 26 Nov 2009 10:19:43 -0800 (PST), TeeSee wrote: &g...

XPath syntax Validation/Help?
I am attempting to use XPath to query for a specific node in the sample XML I've provided below. I'm unsure of the exact XPath syntax, but I believe I need the following query to get the proper node where the node value contains a specific value: /FYIFORM/TEMPLATEINFO/FIELD[@ID = "ODM_NAME"] = "THE FORM I WANT" Once I get a reference to this 'field' node, I can then use the [MyNode.Parent] approach to navigate up to the parent node. It's tHe 'DKey' attribute on that parent node that I'm actually after. Also, I know there's som...

Syntax for dates in business alerts needed
If I know the table and field, what is the syntax in a business alert to send an alert if a PO was approved in the last two days? Something along the lines of: "IF last printed date is > SYSDATE - 2; or phrased in business alert speak, IF POSTATUS = 2 AND POP10100_T1.PRMDATE >= DATEADD(DAY, -30, DATEADD(DAY, -3, GETDATE()) Monson, The keyword in your question is "Approved", which means you are currently using the Purchase Order Enhancements module. What this means is if you want to see the purchase orders approved in the last 2 days you will have to look in th...

no se como hacer la base de datos de esta tarea
no se como hacer la base de datos para esto: Copiar en la parte inferior solo los registros de las Obreras nacidas en el año 87 que vivan en Surco o Miraflores ...

Syntax
Can someone help me to figure what is wrong with my syntax? Thanks... How to open with this ( " ) and sometimes with this ( ' )? SQLString = "insert into WIPRawDetails (JobNumber, PartNumber, W_KittedQty) " & _ "select '" & Me.txtJobNumber & "', " & _ '"& Me.txtPartNumber & "', " &_ '" & Me.I_Qty & "' , " &_ from WIPRawDetails " -- Message posted via http://www.accessmonster.com For one thing, using the single quotes around y...

Ron de Bruin
Hi Ron Your codes "Merge cells from all or some sheets into one Master sheet". Can these be used in a personal module any way as I would like to use it with any work book without copy/pasting the code in each workbook. Thanks. Hi NC Change Thisworkbook to Activeworkbook in the code -- Regards Ron de Bruin http://www.rondebruin.nl "nc" <anonymous@discussions.microsoft.com> wrote in message news:25b501c4c0f4$d9cd7350$a401280a@phx.gbl... > Hi Ron > > Your codes "Merge cells from all or some sheets into one > Master sheet". Can these be...

how to make sure a xsl document has valid xsl syntax? i tried loading it into an xml document but that doesnt show syntax errors inside attributes such as "foo/bar" vs "bar\foo"
how to make sure a xsl document has valid xsl syntax? i tried loading it into an xml document but that doesnt show syntax errors inside attributes such as "foo/bar" vs "bar\foo" Daniel wrote: > how to make sure a xsl document has valid xsl syntax? i tried loading it > into an xml document but that doesnt show syntax errors inside attributes > such as "foo/bar" vs "bar\foo" System.XML performs only checks for the well-formedness of Documents, not for validity. You need a Schema for XSLT wich defines Regular Expressions to check for "sy...

Aqadmcli Syntax
I've tried every permutaion I can think of and still no luck. delmsg queue.com, flags=sender<matt@home.com> delmsg queue.com, "flags=sender<matt@home.com>" delmsg queue.com, flags=sender,matt@home.com nada!! I would like to delete messages from a specific sender (postmaster@domain.com) in every queue. What is the correct syntax? For all domains (as you noted below): delmsg flags=SENDER,sender=postmaster@domain.com For a single domain: delmsg queue.com, flags=SENDER,sender=postmaster@swinc.com Another way to do the same thing: linkaction ln=queue.com, la=MSGACTI...

Database syntax error
I have a database that stores time in military short format. The input mast for the data field on the data entry form is 00:00;0;_ If I enter a time such as 06:35 the form accepts the data and puts it into the database. Now the issue, when the time is saved in the database it drops the leading 0 (zero) storing it as 6:35. I have a duplicate record button on my form that works only when the time saved contains four numbers such as 15:35. Any data with time saved as above which was entered with a leading zero brings an error message that the data entered does not match the i...

Posting to an account that has the "allow account entry" de-select
Has anyone encountered an issue where GP 8.0 allows them to post an otem to an account through A/P processing even though the account was not selected to "allow account entry?" If the account is the default posting account on vendor cards (or vendor class or posting accounts setup), it will allow posting. "Allow account entry" only stops you from being able to select the account or enter the account. It will still post if it is the default account. "Erik B" wrote: > Has anyone encountered an issue where GP 8.0 allows them to post an otem to > an acc...

Confused on syntax
Hello, I confused over the following syntax. Could someone please explain to me exactly what is happening here. ((CEditView*)m_viewList.GetHead())->SetWindowText(NULL); I understand the casted type to the m_viewList.GetHead( ) function, but the ->SetWindowText call on the end is what I've never seen done like this? Is somehow the return pointer from GetHead pointing to the SetWindowText function ? But why would this be? Could not SetWindowText just be called on it's own ? On 3 jul, 13:01, "RB" <NoMail@NoSpam> wrote: > Hello, I confused over the following...

LDAP Filter Syntax Question
I am creating a Query based distribution group. This group will contain all groups and users whos name starts with RX. I believe by default it creates and AND search. I want it to find one OR the other. Here is the filter that was created. What do I need to change to make it search for either a group OR a user name that starts with RX? (&(!cn=SystemMailbox{*})(&(&(&(& (mailnickname=*) (| (&(objectCategory=person)(objectClass=user)(|(homeMDB=*)(msExchHomeServerName=*)))(objectCategory=group) )))(objectCategory=user)(objectCategory=group)(displayName=rx*)(cn=rx*)))) C...

Syntax Error in a SQL string
Can someone spot the syntax error in this SQL string? I tried, but could not see where it is. Thanks in advance, Paulo xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Set qdfTemp = CurrentDb.CreateQueryDef("Current Orders Set", _ "SELECT IIf([Orders]![Status]='REC',[Orders]![DC Cims Week Actual],[Orders]![ETA to DC Cims Week]) " & _ "AS RelevantWeek, Sum(Orders.[Order Qty]) AS [SumOfOrder Qty], Sum(Orders.[Received Qty]) AS [SumOfReceived Qty], " & _ "Sum(IIf([Orders]![Channel]='WHOLESALE',IIf(...

Formual Syntax?
Hi Excel Forum, What do the two dashes (--) mean and do in the following formulas: =SUMPRODUCT(--A1:G1) =SUM(IF(ISNUMBER(--A1:G1),--A1:G1)) entered with ctrl + shift & enter =SUMPRODUCT(--(ISNUMBER(A1:G1))) Please explain. Kind regards, QTE --- Message posted from http://www.ExcelForum.com/ Hi QTE! The -- coerces Boolean returns of TRUE and FALSE to 1 and 0 Do a Google Search on "unary minus" and you'll find plenty of discussions on the topic. -- Regards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au "QTE >" <<QTE.18xd...

EXECUTO SERVI�OS DE AUTOCAD
-- EXECUTO SERVI�OS DE AUTOCAD ATUALIZA�OES DE PLANTAS DE PAPEL FA�O PROJETOS DE *EL�TRICA *HIDR�ULICA *TOPOGRAFIA *ARQUITETURA *LAY-OUT EM GERAL *SISTEMA E COMBATE A INC�NDIO (BOMBEIROS) *PROJETO DE CFTV. CONTATO FONE (011) 7163.4365 RUBENS OU PELO EMAIL trad-1@ig.com.br projetos_10@hotmail.com ...

Why is Access VBA syntax different from Excel syntax?
I just started using Access VBA 2003 and I came across 2 very odd things: Why is the syntax different from Excel? In my Excel macros I use the Microsoft ActiveX Data Objects 2.8 Library. Here is a code sample in Excel: Dim cnn As New Connection Dim rst As New Recordset Dim strSQL As String cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.mdb" Set rst = Nothing strSQL = "SELECT * FROM Table1" rst.Open strSQL, cnn When I tried this in Access it didn't like the "New" qualifier and Open was not a function of the recordset class. W...

invalid date syntax when using findfirst
hey all, here's my problem: i have: table: for distribution of disks form: has a listbox that contains Number, Company, Name and Date from Distr. table, and functions to open the selected record problem: i have no key column in my table, for various reasons, so i've modified the default code Access creates for the listbox to include matching all 4 fields in the listbox, not just the first. works great except when i try clicking on an entry that has no date entered. i get a "syntax error in date" when i click on one of these. how can i modify my code so i include th...