sorting by price and calculating totals excluding hidden rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a spreadsheet of about 400 rows and about 30-35 columns. Some of the columns have vendors and under the vendors are columns showing "unit price" and "extended price". I am trying to sort the data from lowest to highest price. Can anyone tell me how to do this? Also, after I sort by price I would like to total the "extended price" columns. I've hidden some of the rows and when I click on the "sum" button it adds all 400 rows instead of just the rows I am showing. Any suggestions would be greatly appreciated.
 
Have a look in HELP index for SUBTOTAL

--
Don Guillett
SalesAid Software
(e-mail address removed)
Karen Burleigh said:
I have created a spreadsheet of about 400 rows and about 30-35 columns.
Click to expand...
Some of the columns have vendors and under the vendors are columns showing
"unit price" and "extended price". I am trying to sort the data from lowest
to highest price. Can anyone tell me how to do this? Also, after I sort by
price I would like to total the "extended price" columns. I've hidden some
of the rows and when I click on the "sum" button it adds all 400 rows
instead of just the rows I am showing. Any suggestions would be greatly
appreciated.
 
If you have hidden rows by use of a filter, then in all versions you can use
SUBTOTAL() to count/sum etc just visible rows, but this will still include any
manually hidden rows of data. If you have Excel 2003 then there are additional
arguments available that will allow you to also exclude these. You may also
want to take a look at the Data / Subtotals feature, and very likely Pivot
tables as well.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Karen Burleigh said:
I have created a spreadsheet of about 400 rows and about 30-35 columns. Some
Click to expand...
of the columns have vendors and under the vendors are columns showing "unit
price" and "extended price". I am trying to sort the data from lowest to
highest price. Can anyone tell me how to do this? Also, after I sort by price
I would like to total the "extended price" columns. I've hidden some of the
rows and when I click on the "sum" button it adds all 400 rows instead of just
the rows I am showing. Any suggestions would be greatly appreciated.
 
Back
Top