| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Filtered Visible Items that Match Numeric Criteria between two ranges
Hi Domenic,
Sorry, didn't see your amendment before I posted. The Formula works fine with this amendment. Thanks again for your assistance. Cheers, Sam Domenic wrote: Actually, since Data contains numeric values, the values returned by both the LEFT and RIGHT functions need to be coerced into numerical values. Therefore... LEFT(X$1,2) should be LEFT(X$1,2)+0 and RIGHT(X$1,2) should be RIGHT(X$1,2)+0 Hope this helps! -- 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
