Calculation of 3 totals when less than 3 are available

[JSDART!!]

I am working on a stat database for a dart league.
each player has the possibility of playing in 3 games a night.
I have been able to gather all the totals of scores wins lossess number of times played and a percentage on each type of game.
example 601, cricket, 301
when I try to total the numbers of wins acrost all 3 types of games
Total wins:[6w]+[cw]+[3w]
I only get a score when there is data in all 3 other wise it is blank.
I tried Total wins: IIf(isnull([6w]+[cw]+[3w]),0,(6w]+[cw]+[3w]))
and this give me a 0 unless all 3 have scores in them.

I need to know how to give me the total of wins over all and if the total is o the have a 0 entered otherwise give me the total.

any suggestions greatly appreciated.

 

[pbaldy]

TotalWins:nz([6w],0)+nz([cw],0)+nz([3w],0)

 

[JSDART!!]

worked great thanks