| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Filtered Visible Items that Match Numeric Criteria between two ranges
Hi All,
I'm using the Formula below to give me a static count of numeric values that fall within a specified range; say 50-75 inclusive. These ranges are housed in cell X$1. The Named Range "Data" is a dynamic 9 column range spanning many rows. Named Range "Data" is defined as =OFFSET(Sheet1!$H$15,0,0,COUNT(Sheet1!$H:$H),9) Static Count: =COUNTIF(Data,"="&LEFT(X$1,2))-COUNTIF(Data,""&RIGHT(X$1,2)) Based on the above can anyone provide a Formula that provides a Dynamic Count when "Data" is filtered. Thanks Sam -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200609/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count if two columns match different criteria | Excel Worksheet Functions | |||
| How can I count items in a filtered list? | Excel Worksheet Functions | |||
| Find and Count Frequency of Numeric Value in Non-Contiguous Rows | Excel Worksheet Functions | |||
| Count of items using multiple criteria | Excel Worksheet Functions | |||
| Find Count of Items with certain criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
