[JohnS]

I've got 10 Text Form Fields that are all named. I want to average the
numbers that are entered into those fields. The only problem is that not all
fields are used every time. I've tried this two ways and neither seems to
work.

The first is "=average(field1, field2, etc.)". This only works if all
fields are used.

The second way is to sum the results of the fields, then divide that by a
count of the fields in use. To get the count of the fields in use I used a
separate field for each that calculates "=(if, field11,1,0)", then I sum all
those up to get the number. I can get the sum and the count to work, but
when I divide the sum by the count it doesn't work.

Any ideas?