Maybe this:

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

HTH,
Paul


"LOURDES" wrote in message
...
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