|Subject:||Change Sum when Filter Applied|
|Posted by:||Jerry (jponoz…@pacificad.com)|
|Date:||Wed, 8 Oct 2003|
How do you change the bacic formula; =sum(h3:h100) to
tally only the quantities visible in filtered rows rather
than all the rows. I recall adding a $9 or something
similar to the formula to acheive this but I've tried
every pemuation without luck.