you could also use the autofilter to filter out every row with an x. You
would need to replace SUM with SUBTOTAL. The SUBTOTAL function ingnores all
hidden rows.

"Therese" wrote:

Hi
I want to sum the numbers i have written in row a. In row b, I have a row
where I put an x when I want the number beside(the number in row a) to
dissappear. I have tried cond. formatting, but the sum at the bottom counts
the numbers anyway off course. How do I do that? Does anyone have an IF
formular with a circular reference or do I really have to make a new row wih
the numbers?
Thanks in advance :0)
--
Therese