SUM of cells with values coming from a if formula

Hello to all.

My question is: how can i sum several cells which have values coming from an if formula.
Specifying, i have several cells, one for each day, containing an if formula to copy the value of another sheet/cell. The value is considered logical because is the result of the IF clause, but the value is not 0 or 1, itīs the value contained in the other cell.
My problem is that i want to sum all those cells and the result is always zero, meaning that excel is ignoring the cell's values.
If you click on the formulas icon the correct result appears but not on the cell itself.

Can anyone help me?

Thanks to all.

Tiago

The formula is: =IF(Encomenda!B1=1;Encomenda!H12;B4). I have 31 cells with this formula, of course with correspondent indexes.
Encomenda is the name of other sheet. The formula intends to copy the value of a specific cell in the Encomenda sheet, if a specific value (in another Encomenda cell) is met. Otherwise, the value of the actual cell is preserved.
At this moment i can not sum the values of the 31 cells.

Thanks.
Tiago

The formula is: =IF(Encomenda!B1=1;Encomenda!H12;B4).
I have 31 cells with this formula, of course with correspondent indexes.
Encomenda is the name of other sheet. The formula intends to copy the value of a specific cell in the Encomenda sheet, if a specific value (in another Encomenda cell) is met. Otherwise, the value of the actual cell is preserved.
At this moment i can not sum the values of the 31 cells.

Thanks.
Tiago

When you say:

Otherwise, the value of the actual cell is preserved.

do you mean that formula is in cell B4?

Hi.

Yes, the formula is on B4, B5, B6 and so on. I know it contains circular references...

Tiago

Sorry, i'm not following you.
How can the LEFT and FIND functions help me to convert a logical value into a number?

Thanks again.

Tiago

That's it.
I now send the workbook.
The question is, why the sum in the ecomarche sheet, line 35, is not being showed up?

Thanks for you availability.

Tiago

Hi.

Thanks again for your help.
For now, lets forget the circular references.
The Encomenda sheet is updated daily. Each row in the other sheets has the values introduced each day in the Encomenda sheets.
All this logic works, meaning, that the values are copied each day from the Encomenda sheet to all other sheets.
The problem is that at the end of the month i need to sum the values in the matrix (of each sheet except Encomenda).
I donīt know if Excel considers that the matrix values are logical, but it does not sum them up.
If you notice in the workbook i just sent, the first two rows of the Ecomarche sheet have the values 5 (B4 and B5 rows) and the SUM is zero...

Thanks again.

Tiago