searching formula answers

[glazed]

Hi,

I used a formula to sum several columns in 1177 rows. I now want to know which rows had a sum of 0 however when I use the find function it searches for cells that have 0 in the formula not cells that have 0 as the outcome. How do I search for cells that have 0 as an outcome?

[#2]

@glazed 

Perhaps this is what you're looking for. Press Ctrl + F and change "Look in:" to Values.

[#3]

@glazed 

Plus "Match entire cell content"