Simple Sum not working

You never apply namessum to event.value.
Before checking if event.value == 0, you should apply the sum to it:
event.value = namessum;
if (event.value==0) event.value="";}

function SumArray(aFields){
/* sum an Array of field names
Parameters:
aFields = array of field names to sum
Returns sum of fields
*/
var sum = 0; // result of summation of fields
// loop through the array of field names
for(i = 0; i < aFields.length; i++){
// add value of i element from array of field names
sum += Number(this.getField(aFields[i]).value);
} // end of loop
return sum;// return computed value
} // end function SumArray

// define an array of field names to sum
var aFieldNames = new Array("TotalforDayRow1", "TotalforDayRow2",
"TotalforDayRow3", "TotalforDayRow4", "TotalforDayRow5",
"TotalforDayRow6", "TotalforDayRow7", "TotalforDayRow8",
"TotalforDayRow9", "TotalforDayRow10", "TotalforDayRow11",
"TotalforDayRow12", "TotalforDayRow13", "TotalforDayRow14",
"TotalforDayRow15");

//to remove the 0
if (event.value==0) event.value="";}


I would also use a function to perform the count of a number of fields that do not have a null or empty value.

function CountArray(aFields){
/* count an Array of fields names that are not null
Parameters:
aFields = array of field names to sum
Returns sum of fields
*/
var count = 0; // result of the count of non-null fields
// loop through the array of field names
for(i = 0; i < aFields.length; i++){
if(aFields[i].value != '') {
count++; // non-null value - increment count
} // end non-null
} // end of loop
return count == 0? "" : count; // return count or null
} // end function SumArray

Use of functions cuts down on the amount of coding you need to do and reduces changing a repeated set of statements to changing the code in one location. It can also reduce coding effort for multiple forms by including tested funciotns in the other forms.

Thanks to you both for your quick responses.

I tried both methods and the first by try67 did show a blank cell but it showed it when the input cells have values in them as well.

George I copied as pasted yours as is and it came back with
syntax error
25: at line 26
and I cant see want is wrong - but I am a novice.

Any advice greatly appreciated.

Thanks

TiredEyes

Make sure your field calculation order is correct. The total field should calculate after all others.

For the sum function, the very last line that reads:

if (event.value==0) event.value="";}

Should read:

if (event.value==0) event.value="";

There should be no trailing "}".

It also needs to call the function:

function SumArray(aFields){
/* sum an Array of field names
Parameters:
aFields = array of field names to sum
Returns sum of fields
*/
var sum = 0; // result of summation of fields
// loop through the array of field names
for(i = 0; i < aFields.length; i++){
// add value of i element from array of field names
sum += Number(this.getField(aFields[i]).value);
} // end of loop
return sum;// return computed value
} // end function SumArray

// define an array of field names to sum
var aFieldNames = new Array("TotalforDayRow1", "TotalforDayRow2",
"TotalforDayRow3", "TotalforDayRow4", "TotalforDayRow5",
"TotalforDayRow6", "TotalforDayRow7", "TotalforDayRow8",
"TotalforDayRow9", "TotalforDayRow10", "TotalforDayRow11",
"TotalforDayRow12", "TotalforDayRow13", "TotalforDayRow14",
"TotalforDayRow15");

event.value = SumArray(aFieldNames);
//to remove the 0
if (event.value==0)
event.value="";

Of course you could also use the the 'Field is the Sum of:' or the simplified field notatain and then use a validation script to supress the zero result.

The 'count' function need to use the 'the.getField' for checking the value of the fields;

function CountArray(aFields){
/* count an Array of fields names that are not null
Parameters:
aFields = array of field names to sum
Returns sum of fields
*/
var count = 0; // result of the count of non-null fields
// loop through the array of field names
for(i = 0; i < aFields.length; i++){
if(this.getField(aFields[i]).value != '') {
count++; // non-null value - increment count
} // end non-null
} // end of loop
return count == 0? "" : count; // return count or null
} // end function CountArray

// define an array of field names to sum
var aFieldNames = new Array("TotalforDayRow1", "TotalforDayRow2",
"TotalforDayRow3", "TotalforDayRow4", "TotalforDayRow5",
"TotalforDayRow6", "TotalforDayRow7", "TotalforDayRow8",
"TotalforDayRow9", "TotalforDayRow10", "TotalforDayRow11",
"TotalforDayRow12", "TotalforDayRow13", "TotalforDayRow14",
"TotalforDayRow15");

event.value = CountArray(aFieldNames);

And with those two functions you can create an average fiction that does not include null values.

function AvgArray(aFields) {
/* count an Array of fields names that are not null
Parameters:
aFields = array of field names to average
Returns sum of fields
*/
nAverage = ''; // default result
var nCount = CountArray(aFieldNames)
if(nCount != 0) {
nAverage = SumArray(aFieldNames) / nCount;
}
return nAverage;
} // end AvgArray

It is best to place the code for the functions as document scripts so the code is available to all fields.

Sorry for the late response.

I have just tried George's response and it works perfectly!
Thank you to all those that were kind enough to respond.

Sincerely

TiredEyes