I want to sum values in rows and coloums of a table.

tarunkhatri

I want the result to be displayed at the last row and last colom of every row...

I have found this javascript code from somewhere.to do the same.. But the problem is . I am confused how should I call this function in my actual table rows and coloms...

Expand|Select|Wrap|Line Numbers

 <script language="javascript">

function sumup( o ) {

 var t = [], cell,

  row = document.getElementById( 'sumtable' ).rows,

  i = row.length - 1,

  lastrow = row[i];

 while(i--) {

  cell = row[i].cells; j = cell.length;

  while(j--) {

   if( !t[j] ) { t[j] = 0; }

   t[j] += parseFloat( cell[j].firstChild.nodeValue ) || 0;

  }

 }

 j = t.length; while(j--) {

  if( lastrow.cells[j] ) { lastrow.cells[j].firstChild.nodeValue = t[j]; }

 }

 o.disabled = true;

}

</script>

I know that I to the table I have to give id = sumtable .. but wht should I do to get the result in the last row and table...

PLease please help me... as i m new to javascript and programmin

Dormilich

Quote:

Originally Posted by tarunkhatri

but wht should I do to get the result in the last row and table...

call the function with the desired event. the function takes care of the rest.

tarunkhatri

Thanks for quick answer Dormilich. I am calling the function in the followin manner on the onchange event.. but is not working..

Expand|Select|Wrap|Line Numbers

 <table width="200" border="1" id = "sumtable">

<tbody id = "sumtable>

  <tr>

    <td><input type="text" id="Row 1 colom 1" name="value1" value ="" size = "4"/ onChange = "sumup()"></td>

    <td><input type="text" id="Row 1 colom 1" name="value2" value ="" size = "4" onChange = "sumup()"/></td>

    <td><input type="text" id="Row 1 colom 1" name="value3" value ="" size = "4" onChange = "sumup()"/></td>

    <td><input type="text" id="Row 1 colom 1" name="value4" value ="" size = "4" onChange = "sumup()"/></td>

    <td><input type="text" id="answer" name="answer" value="" DISABLED/></td>

  </tr>

  <tr>

    <td><input type="text" id="value1" name="value1" value ="0" size = "4" onChange = "sumup()"/></td>

    <td><input type="text" id="value2" name="value2" value ="0" size = "4"/ onChange = "sumup()"></td>

    <td><input type="text" id="value3" name="value3" value ="0" size = "4"/ onChange = "sumup()"></td>

    <td><input type="text" id="value4" name="value4" value ="0" size = "4"/ onChange = "sumup()"></td>

    <td><input type="text" id="answer" name="answer" value="" DISABLED/></td>

Dormilich

the programme expects to have the values to count as text of the table cells, not as input fields.

counting the values of input fields is much easier, because you can get the fields by a common name.

sumup() is missing the input parameter

PS. please use tags when posting code

PPS. the IDs in the first <tr> are invalid.

tarunkhatri

Hummm.... You are rgt I want the values to be input types .. and as soon as any value in the grid is changed I want the sum to e updated......

Even I want to get all the fields by common name.... But if u can please help me how can I set the parameter in sumup() which is missing and than call it in the actual HTML .. As today is only my second day with javascrpt to vry much confused...
Many Thanks

Dormilich

Quote:

Originally Posted by tarunkhatri

As today is only my second day with javascrpt to vry much confused...

then it’s best to read a tutorial, there are some links in the forum stickies.

Quote:

Originally Posted by tarunkhatri

But if u can please help me how can I set the parameter in sumup() which is missing and than call it in the actual HTML ..

you need a different function because this function doesn’t fit your needs.

tarunkhatri

Ohh .. is it... I appriatiate your effort thanks very much..... But if you find a function thts does this job please reply...As I have a deadline of today from my boss :( ...