| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I adapt the included filter example to search for more th.
=SUMPRODUCT(--(SUBTOTAL(3,OFFSET(INDEX($E$16:$E$1998,1,1),ROW($E $16:$E$1998)-
ROW(INDEX($E$16:$E$1998,1,1)),0))=1),--($E$16:$E$1998="Y")) I am using this formula to calculate cells and then sort columns also. I would like to be able to calculate other items in the same field as well those that are equal to "Y". For example, subtotal everything in cells E16:E1998 that contains either a "Y", "YY" or a "YN". Is there a OR function I can place in this formula that will enable this to happen? Thanks in advance for any help you may offer! - Cheryl |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
| Pivot table and filter | New Users to Excel | |||
| Advanced Filter: No Filter | Excel Discussion (Misc queries) | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
| auto filter question | Excel Worksheet Functions | |||
Linear Mode
