Change Sum when Filter Applied

Giganews Newsgroups
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.

Replies