Hi
I'm stuck - I need a function that sums up a simple calculation. I'm using SUM and also tried SUMIF, however it still gives me #value!
=SUM((B22*B23);(B27*B28);(B32*B33);(B37*B38)) it works perfect if all the required cells have a number, however if one of the cell is blank it doesn't return the correct calculation ignoring the blank.
I'm stuck - I need a function that sums up a simple calculation. I'm using SUM and also tried SUMIF, however it still gives me #value!
=SUM((B22*B23);(B27*B28);(B32*B33);(B37*B38)) it works perfect if all the required cells have a number, however if one of the cell is blank it doesn't return the correct calculation ignoring the blank.