there is a function in MS Excel called "sumproduct" which multiplies the componenets in an array or arrays, then totals the result, eg : =SUMPRODUCT(D4:D20,B4:B20) ...Job done...Enjoy
Question about Windows Server Standard 2003 for PC
Re-Synching problem with RAID5 Arrays in windows 2003 server I have some drives in an external array box. When I create a RAID5 array it works fine. But when I move the drives to other slots or ...
Question about Excel for PC
Excel will not displaying the results of a trend array formula I have column A showing months 1 to 12, and column B is 12 values. In column C I have the formula "{=TREND(C3:C14,A3:A14)}". I have use ...
Question about Windows XP Professional With Servise Pack 2 (e8503040) for PC
To merge two arrays A and B in java source code. A java program.pls help me out. Do you need them to be sorted after the merge and are they already sorted? If not, then what you can do is create a ...
Change of colummn Someone to help me describe a macro in which I distribute some values in different columns, please. Ex. A B C D E 1 10 20 30 40 50 * This is the value to ditribute 2 1 2 3 4 5 * I ...
need an excel formula. I'm not sure how to make this work If Sheet3! I2= "WA" and Sheet3!H2 is "Vancouver" or "Camas" or "Ridgefield" or "Washougal" or "Stevenson" or "Hockinson" return a value of x. ...
Question about Windows Small Business Server (SBS) 2003 Premium Edition with Service Pack 1 (SP1) Upgrade Version for PC (5 Client/s) (T7501256)
While using "Adaptec SATA HostRAID Controller";configuring RAID 1, When choosing to "Rebuild array" error message: "Media Error happended during the data transfer. The array will not be optimal" Check
Question about Windows XP Professional With Servise Pack 2 (e8503040) for PC
merging two arrays and sort them NEED A NEW KEY THE ONE ON THE BOX WONT WORK Hello my friend, try the concept of the program by studying its flow. Here's some program code done using Java Programming ...
Question about Visual Basic Enterprise Edition 6.0 (361-00667) for PC
how to form an array in visual basics(Express) samples of arrays in vb.net 1) dim array(3) as integer array(0)=1 array(1)=2 array(2)=3 array(3)=4 2) dim array() as integer array=new integer(){1,2,3,4}
Question about Visual C++ Professional Edition 40 Full Version for PC
declare 2 arrays with 5 as index value of each. the user will input values to the first array(user-defined). Transfer value of the first array to the second array.Get the sum of the second ...
Usually answered in minutes!
7,276 Questions
4,613 Questions
4,482 Questions
4,191 Questions
3,681 Questions