Thread: If formular
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Therese
 
Posts: n/a
Default If formular

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