| 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 Domenic,
Thanks for reply. The Formula is not returning the desired result. It returns zero. Further help appreciated. Cheers, Sam Domenic wrote: Try... =SUM(IF(SUBTOTAL(3,OFFSET(Data,ROW(Data)-MIN(ROW(Data)),0,1)),IF(Data=LE FT(X$1,2),IF(Data<=RIGHT(X$1,2),1)))) ...confirmed with CONTROL+SHIFT+ENTER. Hope this helps! -- Message posted via http://www.officekb.com |
| Reply |
| 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) | |||
Hybrid Mode
