IF Function

[Sharon]

I am trying to add up totals using the IF function rather than the SUM
function? Can anyone give me any pointers on where I am going wrong. I have
four columns of figures that need to work together in some way.

 

[Gordon]

I am trying to add up totals using the IF function rather than the SUM
function? Can anyone give me any pointers on where I am going wrong. I
have
four columns of figures that need to work together in some way.

Firstly, how is this a template question?
Secondly an IF statement is in the form of "if this is true, do this, if
not, do that" so what are you trying to achieve with this IF statement that
a SUM cannot?