| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
count & Autofilters
Hey,
Anyone know if a "COUNTA" will work if you have an AUTOFILTER in place... I apply the filter and it counts the hidden cells still, is there a way round this??? Ta very much in advance John |
|
#2
|
|||
|
|||
|
Use the SUBTOTAL worksheet function. For example:
=SUBTOTAL(3,A2:A1000) To learn more, see: http://www.techonthenet.com/excel/formulas/subtotal.htm HTH Jason Atlanta, A -----Original Message----- Hey, Anyone know if a "COUNTA" will work if you have an AUTOFILTER in place... I apply the filter and it counts the hidden cells still, is there a way round this??? Ta very much in advance John . |
|
#3
|
|||
|
|||
|
Hi Jason
Once again you have answered my prayers to what seemed like an impossibility to me!!! Thank You "Jason Morin" wrote: Use the SUBTOTAL worksheet function. For example: =SUBTOTAL(3,A2:A1000) To learn more, see: http://www.techonthenet.com/excel/formulas/subtotal.htm HTH Jason Atlanta, A -----Original Message----- Hey, Anyone know if a "COUNTA" will work if you have an AUTOFILTER in place... I apply the filter and it counts the hidden cells still, is there a way round this??? Ta very much in advance John . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
| count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
| Count number to reach a cumulative value | Excel Worksheet Functions | |||
| Count If Formula | Excel Worksheet Functions | |||
| count based on two fields - need quickly | Excel Worksheet Functions | |||
Linear Mode
