Isnumber, match, sumif,lookup

I HAVE ADDED AN ATTACHMENT. REFER FORMULA IN YELLOW. THANKS/DAVID

Hello - can anyone assist. Thanks in advance./David


=SUMPRODUCT(ISNUMBER(MATCH('Hayys BF BOQ'!$D$13:$D$32,{"CO"},0))*ISNUMBER(MATCH('Hayys BF BOQ'!$G$13:$G$32,{"C"},0))*ISNUMBER(MATCH('Hayys BF BOQ'!$H$13:$H$32,{"Y"},0))*'Hayys BF BOQ'!$DI$13:$DI$32*'Hayys BF BOQ'!$HI$13:$HI$32*SUMIF('CAPEX Unit Prices'!$C$5:$C$15,'Hayys BF BOQ'!$HD$13:$HD$32,'CAPEX Unit Prices'!H$5:H$15)*'Hayys BF BOQ'!H37)

The following two arrays are multiplied together - subject to other calculations numbers may / may not appear in those rows. This followng calculation is subject to three ISNUMBER conditions.

Hayys BF BOQ'!$DI$13:$DI$32*'Hayys BF BOQ'!$HI$13:$HI$32

The product of the above is multiplied by another identical array which is price - NOT all the same rows as those in the above will contain numbers - some a blank.

The following component is where the ERROR is:

SUMIF('CAPEX Unit Prices'!$C$5:$C$15,'Hayys BF BOQ'!$HD$13:$HD$32,'CAPEX Unit Prices'!H$5:H$15)

If not all the same rows contain a number, then this SUMIF returns a 0, which obviously 0's the whole sytax.

Thanks in advance/David

Firstly, if you are only matching one string to each range you don't need ISNUMBER(MATCH())

simply: ('Hayys BF BOQ'!$D$13:$D$32="CO") should suffice.

Probably the SUMIF part is where you need the ISNUMBER(MATCH() instead...

Secondly, I have no idea what you are trying to do.... Can you spell it all out?