eggyjla
Active Member
- Joined
- Dec 16, 2004
- Messages
- 346
I'm looking for some assistance generating a SUMPRODUCT formula in cell J10 which produces the results of cell K10. I was having difficulty creating an array which determines the Max(Sum)). Any help would be greatly appreciated.<HTML><HEAD>
******** Langage JavaScript><!---
function ViewSource() {
var HtmlSource;
HtmlSource = document.all.ForSubmit.innerHTML;
HtmlSource = RetDeleted(HtmlSource);
document.write('<HTML><BODY BGCOLOR=#E0F4EA><CENTER><FORM><TEXTAREA ROWS=30 COLS=90%>');
document.write(HtmlSource);
document.write('</TEXTAREA></FORM></CENTER></BODY></HTML>');
}
function CopyToClipBoard() {
var HtmlSource;
HtmlSource = document.all.ForSubmit.innerHTML;
HtmlSource=RetDeleted(HtmlSource);
window.clipboardData.setData("Text",HtmlSource);
alert('Html source of above image\n\nhas been copied to your clip board\n\nJust paste it into Message Body\n\nIf you cannnot paste source from clip board,\n\nclick [View Source] button and paste manually.');
}
function RetDeleted(targetstring) {
if (targetstring.indexOf(unescape('%0D%0A')) > -1) rcode = unescape('%0D%0A')
else if (targetstring.indexOf(unescape('%0A')) > -1) rcode = unescape('%0A')
else rcode = unescape('%0D');
i = 0;
p = '';
while (targetstring.indexOf(rcode,i) != -1) {
m = targetstring.indexOf(rcode,i);
p += targetstring.substring(i,m);
i = m + rcode.length;
}
p += targetstring.substring(i,targetstring.length);
return p;
}
*********></HEAD><BODY BGCOLOR=#E0F4EA><CENTER><FONT COLOR=#339966 SIZE=5>[HtmlMaker 2.42]</FONT><BR><BR></CENTER><HR><BR><SPAN id='ForSubmit'>
******** LANGUAGE="JavaScript" ************************************************************************>
</SPAN><BR><CENTER><HR><FORM NAME='form1'><INPUT TYPE='Button' value='Please click this button to send the source to clipbord' *******='CopyToClipBoard();'><INPUT TYPE='Button' value='View Source' *******='ViewSource();'></FORM><FONT COLOR=#339966 SIZE=2> This free code was written by Colo and Ivan F Moala:[HtmlMaker 2.42] - 15th May 2003</FONT><BR><FONT COLOR=#339966 SIZE=2>Code mods by Ivan F Moala - 15th May 2003</FONT></HR></BODY></HTML>
******** Langage JavaScript><!---
function ViewSource() {
var HtmlSource;
HtmlSource = document.all.ForSubmit.innerHTML;
HtmlSource = RetDeleted(HtmlSource);
document.write('<HTML><BODY BGCOLOR=#E0F4EA><CENTER><FORM><TEXTAREA ROWS=30 COLS=90%>');
document.write(HtmlSource);
document.write('</TEXTAREA></FORM></CENTER></BODY></HTML>');
}
function CopyToClipBoard() {
var HtmlSource;
HtmlSource = document.all.ForSubmit.innerHTML;
HtmlSource=RetDeleted(HtmlSource);
window.clipboardData.setData("Text",HtmlSource);
alert('Html source of above image\n\nhas been copied to your clip board\n\nJust paste it into Message Body\n\nIf you cannnot paste source from clip board,\n\nclick [View Source] button and paste manually.');
}
function RetDeleted(targetstring) {
if (targetstring.indexOf(unescape('%0D%0A')) > -1) rcode = unescape('%0D%0A')
else if (targetstring.indexOf(unescape('%0A')) > -1) rcode = unescape('%0A')
else rcode = unescape('%0D');
i = 0;
p = '';
while (targetstring.indexOf(rcode,i) != -1) {
m = targetstring.indexOf(rcode,i);
p += targetstring.substring(i,m);
i = m + rcode.length;
}
p += targetstring.substring(i,targetstring.length);
return p;
}
*********></HEAD><BODY BGCOLOR=#E0F4EA><CENTER><FONT COLOR=#339966 SIZE=5>[HtmlMaker 2.42]</FONT><BR><BR></CENTER><HR><BR><SPAN id='ForSubmit'>
******** LANGUAGE="JavaScript" ************************************************************************>
Book2.xls | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | |||
3 | NORMAL | |||||||||||
4 | ||||||||||||
5 | Case1 | Case2 | Case3 | Case4 | ||||||||
6 | Item1 | 29.12368 | 31.01068 | 31.07068 | 25.07868 | |||||||
7 | Item2 | 74.11632 | 80.01732 | 79.75712 | 86.54312 | |||||||
8 | Item3 | 79.88914 | 84.5264 | 97.80012 | 83.39112 | |||||||
9 | Item4 | 79.76089 | 85.63879 | 86.47619 | 92.50019 | |||||||
10 | Item1 | 0 | 40.00868 | |||||||||
11 | ||||||||||||
12 | ALTERNATE | |||||||||||
13 | Summer | |||||||||||
14 | Case1 | Case2 | Case3 | Case4 | ||||||||
15 | Item1 | 3.231 | 7.252 | 6.802 | 14.93 | |||||||
16 | Item2 | 0.1248 | 0.1248 | 0.1848 | 0.2448 | |||||||
17 | Item3 | 3.0728 | 3.0728 | 3.4684 | 3.4684 | |||||||
18 | Item4 | 0.3128 | 0.3128 | 16.8044 | 21.6332 | |||||||
Sheet1 |