Brian Dunning's FileMaker Custom Functions

SUMLIST ( list )

sums the numbers in a list

  Average rating: 3.9 (38 votes) Log in to vote

Martin Spanjaard   Martin Spanjaard - Show more from this author
Trias Digitaal

Share on Facebook Share on Twitter

  Sample input:
SUMLIST ( 2.5¶3 )
  Sample output:

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Adds the numbers in a list. We use it on our invoices, where the user is free to put the amounts in a text field.

It recursively takes the first number off the list and adds it to the rest of the list, till the list is empty.

Formatting is done recursively by two other custom functions.



unin   unin, japan
Feb 8, 2010
Bart Bartholomay   Bart Bartholomay, Vero Beach, FL
Feb 9, 2010
Why not:

Martin Sorich   Martin Sorich, San Jose, CA
May 14, 2010

Clever, but in FMP 10, 11 extra "+" is appended to end of string which does not evaluate properly. I suggest:

Evaluate( Left( Substitute (list;¶;"+") ; Length ( list ) -1 ) )


List is delimited by ¶ and Sum function does not work.
Tom Fitch   Tom Fitch
May 25, 2011
@Martin - There's nothing inherently wrong with unin's function, it just assumes a proper list. It's the LeftValues and RightValues functions that are appending the carriage return.

@unin - That is so cool!

Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: