Forum Discussion

glazed's avatar
glazed
Copper Contributor
Aug 11, 2020

searching formula answers

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?

Resources