ExcelBanter - formulas "IF, THEN"

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formulas "IF, THEN" (https://www.excelbanter.com/excel-worksheet-functions/143712-formulas-if-then.html)

LOURDES

formulas "IF, THEN"

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

formulas "IF, THEN"

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

All times are GMT +1. The time now is 12:45 PM.