Likely the IF functions are returning text digits rather than numbers.

Jerry

Banana wrote:

I have a row of cells with IF functions that return a number in each cell. I
have a SUM total at the end of the row which returns a zero valuve! Why is
the SUM function returning a zero value?