View previous topic :: View next topic |
Author |
Message |
freakazoid Red Pill
Joined: Dec 01, 2005 Posts: 7
|
Posted: Thu Dec 01, 2005 1:44 pm Post subject: Subtotal function |
|
Background:
I have a column list of weights in grams. An autofilter was placed so that I can view only the rows I need. In another area I have a formula, =SUBTOTAL(9; H7:H43)/1000, to convert those grams to kilograms and have used the subtotal function so I can get a total of only the visible weights after applying the autofilter.
Problem:
The formula isn't updating my total in the visible cells. It stays just as it was before the autofilter is applied. If I change the formula slightly (delete or add a space in front of the H7) it will then make the change to the total but will not change it back when I turn off the autofilter.
Does anybody know how to solve this problem? Thanks. |
|
Back to top |
|
|
OPENSTEP The One
Joined: May 25, 2003 Posts: 4752 Location: Santa Barbara, CA
|
Posted: Sun Dec 04, 2005 8:49 pm Post subject: |
|
There may be some type of "autoupdate" featuer that is turned off for some reason. I think it was in one of the submenus and it may be disabled by default to make performance seem snappier.
If that's not it, then I'd recommend checking oooforum.org or the OpenOffice.org site to see if there are any outstanding known bugs where dependency analysis for cell formulas aren't being properly constructed and autoupdate of formula results is not being performed.
ed |
|
Back to top |
|
|
freakazoid Red Pill
Joined: Dec 01, 2005 Posts: 7
|
Posted: Wed Dec 07, 2005 10:28 am Post subject: I figured it out |
|
I just needed a better formula. |
|
Back to top |
|
|
jjmckenzie51 The Anomaly
Joined: Apr 01, 2005 Posts: 1055 Location: Southeastern Arizona
|
Posted: Wed Dec 07, 2005 8:32 pm Post subject: Re: Solution??? |
|
freakazoid wrote: | I just needed a better formula. |
So, what was this better formula?
James |
|
Back to top |
|
|
freakazoid Red Pill
Joined: Dec 01, 2005 Posts: 7
|
Posted: Thu Dec 08, 2005 7:56 am Post subject: Re: Solution??? |
|
=SUM((A7:A45=1)*I7:I45)/1000
What it does is look at column A cells, and, if there is a 1 there, it will sum the cells in column I then divide by 1000. The formula above works in NeoOffice, but Excel wants a different formula to do the same thing,
=SUMIF(A7:A45,1,I7:I45)/1000
I couldn't get the sumif function to work right in NeoOffice. Both are array formulas.
jjmckenzie51 wrote: | So, what was this better formula?
James |
|
|
Back to top |
|
|
|