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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|