#3 BitSheets new Function

[Wolff Borg]

A new function has been contributed to TikiSheet. It
will soon be in Tiki's CVS 1.9 branch.

// SUMIF {{{1
function SUMIF( ifList, tests, sumList )
{
var testArray = isArray(tests);
var total = 0;

for (var index = 0; index < sumList.length &&
index < ifList.length; index++)
{
if (!isNaN(sumList[index])) {
var addValue = false;
if (testArray) {
for (var testIndex = 0;
testIndex < tests.length && !addValue;
testIndex++) {
addValue =
(tests[testIndex] == ifList[index]);
}
}
else {
addValue = (tests ==
ifList[index]);
}

if (addValue) {
total += sumList[index];
}
}
}

return total;
}

[Tomasz Kalkosinski]

Well it's been 3 years :D Can I close this one? If you won't respond till monday I will :)