I have a series of fields where I use a formula, very much like this one:

If([Initial Elbow Reps > 3 per min. / Static Hold > 2 min.]=true,1)

This formula works, but what I'd like to do is have final "Total" field, where I total all of these previous fields. However, the most logical formula that I set up:

Sum([field 1]+[field 2]+[field 3]...) only totals when ALL formula fields have been entered. For example, I have 10 formula fields, but unless all 10 are entered, the "Total" field formula doesn't work and the "total" field remains empty.

I know I'm missing something but can't wrap my mind as to what it could be. Any help would be appreciated!

If([Initial Elbow Reps > 3 per min. / Static Hold > 2 min.]=true,1)

This formula works, but what I'd like to do is have final "Total" field, where I total all of these previous fields. However, the most logical formula that I set up:

Sum([field 1]+[field 2]+[field 3]...) only totals when ALL formula fields have been entered. For example, I have 10 formula fields, but unless all 10 are entered, the "Total" field formula doesn't work and the "total" field remains empty.

I know I'm missing something but can't wrap my mind as to what it could be. Any help would be appreciated!