formulas "IF, THEN"

[Guest]

I need a formula that would give me the following information:
If the total in column B=0 from sheet Feb then the total from column B from
sheet Jan should be used in sheet Mar

ex.
Sheet Feb column b=0
Sheet Jan column b=2
Sheet Mar should show 2

 

[PCLIVE]

Maybe this:

=IF(SUM(Feb!B:B)=0,SUM(Jan!B:B),SUM(Feb!B:B))

HTH,
Paul