sum index match

[BrutalLogiC]

Hi I'm trying to amend the formula below so that the result is the sum of all data in the respective columns and rows matching cells C19 and E17. I might have the totally wrong formula!

=INDEX('Cashflow labour'!$CM$26:$EA$128,MATCH($C19,'Cashflow labour'!$CM$26:$CM$128,0),MATCH(E$17,'Cashflow labour'!$CM$24:$EA$24,0))

 

[AlanY]

try this

=SUMPRODUCT(('Cashflow labour'!$CM$26:$CM$128=$C19)*('Cashflow labour'!$CN$24:$EA$24=E$17)*'Cashflow labour'!$CN$26:$EA$128)

 

[BrutalLogiC]

Thanks AlanY!

 

[AlanY]

you're welcome
just a stab in the dark