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 ***