I'm not sure what your trying to do but the answer to your question is that
your formula doesn't do anything if A2=C2 is true or false because (F2:G2)
isn't actually an instruction to do anything. You might try:-

=IF(A2=C2,SUM(F2:G2),SUM(H2:I2))

Mike

"joker_r_me" wrote:

What's wrong with this formula?

=IF(A2=C2,(F2:G2),(H2:I2))

all columns referenced are numbers.
I'm trying to say if A2=C2 then insert F2-G2 columns
but if A2 doesn't = C2 then insert H2-I2 columns