Re: Change Sum when Filter Applied

Giganews Newsgroups
Subject: Re: Change Sum when Filter Applied
Posted by:  Peo Sjoblom (terre…@mvp.org)
Date: Wed, 8 Oct 2003

=SUBTOTAL(9,H3:H100)

--

Regards,

Peo Sjoblom

"Jerry" <jponoz…@pacificad.com> wrote in message
news:04c201c38dde$70deeda0$a30128…@phx.gbl...
> 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

None

In response to

Change Sum when Filter Applied posted by Jerry on Wed, 8 Oct 2003