Summing cells where one has a formula

[jacko311]

I am attempting to use the if function that looks at a cell to see if it is a certain value and if so it adds the value of the cell above with another cell.

Here is the formula in cell AH26: =IF(G26=Variables!$F$4,AH25+AF26,AH25)

the problem is if the G25 did not equal Variables!F4 then AH25 is basically zero or the formula so when cell G26 does equal Variables!F4 then AH26 is supposed to sum AH25 with AF26 but AH25 cell's contents are a formula. How do I get it to ignore the formula and add AF26 with zero instead of the formula?

[ConneXionLost]

Hi jacko311,

Your description appears to ask for this:

Please Login or Register  to view this content.

If this isn't what you're looking for, then please re-state the problem.

Cheers,

[jacko311]

No that is not correct: the formula is AH26: =IF(G26=Variables!$F$4,AH25+AF26,AH25)

the problem is that if AH25 did not return a true statement and fill the cell with a number then the result is #Value!

[daddylonglegs]

Try using SUM, i.e.

=IF(G26=Variables!$F$4,SUM(AH25,AF26),AH25)

[jacko311]

that was it, thanks very much for your help!