Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ISNUMBER Logical test
I am trying to Sum all the data in COLUMN H that meets ALL my
specifications. Column B data must start with 313- or 312- Column K contains CT08 Column R contains B60 I am having trouble with the AND/OR logic in column B... here is the formula without the OR test... SUMPRODUCT(--ISNUMBER(SEARCH("313-*",'Sheet1'!$B$2:$B$60000)),--('Sheet1 '!$K$2:$K$60000="*ct08*"),--('Sheet1'!$R$2:$R$60000="B60"), 'Sheet1'!$H$2:$H$60000) thanks all *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Logical Test | Excel Worksheet Functions | |||
logical test | Excel Worksheet Functions | |||
logical test | Excel Worksheet Functions | |||
Logical test | Excel Discussion (Misc queries) | |||
Logical test | Excel Programming |