- Oct 20, 2003
I've searched for it, but perhaps I've missed it. I have data in column e starting at e5:e46. Most of the rows are hidden because they are conditionally set that way because there is no data in one of the other columns. In e47 I have a sum of e5:e46 and it works just fine. What I am looking for is a formula that when put in e47 will sum ONLY the visible data. So if only 5 rows are showing, it only sums those 5 rows, if I unhide the rows it will sum all the rows or however many are showing.