=SUMPRODUCT(--(OR(LEFT(Sheet1!$B$2:$B$60000,3)="312",LEFT(Sheet1 !$B$2:$B$60000,3)="313")),--(Sheet1!$K$2:$K$60000="*ct08*"),--(Sheet1!$R$2:$R$60000="B60"),Sheet1!$H$2:$H$60000)

"Kirill V" wrote:

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