|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 15th, 2004, 09:27 PM
|
|||
|
|||
Summing Filtered Rows
Ok, I've filtered my spreadsheet using AutoFilter and
selecting one of the availble cell contents as a criteria. Now that I've got a table that shows only the rows that contain my selected filter qualification for that column, I want to sum all the numbers in ONLY the filtered adjacent column. How can I do this? Whenever I try to sum that column, I get sum for entire UNFILTERED column, not just the filtered items. Thanks! 
|
|
#2
March 15th, 2004, 09:35 PM
|
|||
|
|||
|
Summing Filtered Rows
=SUBTOTAL(9,A2:A1000)
HTH. Best wishes Harald skrev i melding ... Ok, I've filtered my spreadsheet using AutoFilter and selecting one of the availble cell contents as a criteria. Now that I've got a table that shows only the rows that contain my selected filter qualification for that column, I want to sum all the numbers in ONLY the filtered adjacent column. How can I do this? Whenever I try to sum that column, I get sum for entire UNFILTERED column, not just the filtered items. Thanks!
|
|
#3
March 15th, 2004, 09:40 PM
|
|||
|
|||
|
Summing Filtered Rows
Use SUBTOTAL:
=SUBTOTAL(9,A1:A10) where the first argument denotes the type of calcaluation to perform: 1 AVERAGE 2 COUNT 3 COUNTA 4 MAX 5 MIN 6 PRODUCT 7 STDEV 8 STDEVP 9 SUM 10 VAR 11 VARP -- HTH Jason Atlanta, GA -----Original Message----- Ok, I've filtered my spreadsheet using AutoFilter and selecting one of the availble cell contents as a criteria. Now that I've got a table that shows only the rows that contain my selected filter qualification for that column, I want to sum all the numbers in ONLY the filtered adjacent column. How can I do this? Whenever I try to sum that column, I get sum for entire UNFILTERED column, not just the filtered items. Thanks! .
|
|
#4
March 29th, 2004, 09:19 PM
|
|||
|
|||
|
Summing Filtered Rows
Does anyone know how to COUNT the number of rows that are
a result of using the Autofilter? I have 2 columns. I'm using SUBTOTAL(9,a1..a500) to sum the values in those rows, but I have a second column that I need to just count the # rows. ??? ANy help would be appreciated? Thanks! -----Original Message----- =SUBTOTAL(9,A2:A1000) HTH. Best wishes Harald skrev i melding ... Ok, I've filtered my spreadsheet using AutoFilter and selecting one of the availble cell contents as a criteria. Now that I've got a table that shows only the rows that contain my selected filter qualification for that column, I want to sum all the numbers in ONLY the filtered adjacent column. How can I do this? Whenever I try to sum that column, I get sum for entire UNFILTERED column, not just the filtered items. Thanks! .
|
|
#5
March 29th, 2004, 09:22 PM
|
|||
|
|||
|
Summing Filtered Rows
Hi
try =SUBTOTAL(3,B1:B500) -- Regards Frank Kabel Frankfurt, Germany Carol wrote: Does anyone know how to COUNT the number of rows that are a result of using the Autofilter? I have 2 columns. I'm using SUBTOTAL(9,a1..a500) to sum the values in those rows, but I have a second column that I need to just count the # rows. ??? ANy help would be appreciated? Thanks! -----Original Message----- =SUBTOTAL(9,A2:A1000) HTH. Best wishes Harald skrev i melding ... Ok, I've filtered my spreadsheet using AutoFilter and selecting one of the availble cell contents as a criteria. Now that I've got a table that shows only the rows that contain my selected filter qualification for that column, I want to sum all the numbers in ONLY the filtered adjacent column. How can I do this? Whenever I try to sum that column, I get sum for entire UNFILTERED column, not just the filtered items. Thanks! .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
