Getting #ERROR on Sum

[Stephen]

I have a continuous for with mutiple fields. I have totals at the bottom of
the form which work as follows:

data fields: XS, S, M, L (these are quantities). Sometimes there is NO
value, example: the customer only ordered M and L.

XS S M L
Style1 3 4 4
Style2 4 2 2 1

(expected)
Totals: 7 6 6 1

results)
Totals: #error #error #error #error

Formulas
=sum(XS) =sum(S) .......

At the bottom of the form, I have XSSUM = sum([XS])
I use the same format throughout the totals at teh bottom.

For ALL of the totals, I am getting #Error.

Help?

-Stephen

 

[JudithJubilee]

Hello there,

It maybe that you have one of the field you are trying to
Sum set as Text.

You need to go to your table and make sure your quantity
fields are set as number.

Hope this helps

Judith