formula

  • Thread starter Thread starter Tester
  • Start date Start date
T

Tester

Hello there,
I have excel 2000. I have a formula to add column 1[sum of the column1
cells].
If I do a sort of the data the formula does not reflect the sorted
data. What can I do to account for that?
Thanks, T
 
Hi,

Actually I need to use count(A:A) which does not seem to work properly
when I sort cells based on some criteria.
Thanks
 
Well, you did say "add column 1" in your first post.

Please explain what you mean by "does not seem to work properly".

Does it give different answers than before the sort? Do you get
errors?

What do you mean by sorting "based on some criteria"?

More details please.

Pete
 
Well, you did say "add column 1" in your first post.

Please explain what you mean by "does not seem to work properly".

Does it give different answers than before the sort? Do you get
errors?

What do you mean by sorting "based on some criteria"?

More details please.
Click to expand...
Hi,
So if I sort a column by some criteria then only relevant records
would show up from a column from example, so not all records, and only
these relevant records need to have some number column added to the
formula. Formula adds by default all records. Thanks, T
 
You are not sorting by criteria............you are filtering.


Gord Dibben MS Excel MVP
 
As Gord says, you are filtering, not sorting.

Have a look at the SUBTOTAL function in XL Help - if you were to use:

=SUBTOTAL(9,A:A)

for example, then this will only add the visible (filtered) records
instead of SUM(A:A) which will add them all. The parameter 9 defines
the action of the SUBTOTAL function (in this case SUM), but there are
several other numbers that can be used eg for COUNT, COUNTA, AVERAGE
etc. All detailed in Help.

Hope this helps.

Pete
 
Back
Top