Adding multiple lookups using INDEX MATCH functions

[DaithiB]

I am trying to add up certain numbers in each row. So each time 4.4 shows up i want the number to the left of it (can be a different number). At the moment i have INDEX(C5:CN,MATCH($CT$2,C5:CN,0)-1).
CT2=4.4
This gives me the number left to the first occurrence of 4.4, but I am trying to get all of them added together. I have tried the SUMPRODUCT and SUMIF functions but cant seem to get it to work. I am probably just not doing it right

Any help would be much appreciated!

 

[Fluff]

Hi & welcome to MrExcel
maybe
=SUMIF(C5:C10,CT2,B5:B10)

 

[DaithiB]

Hi Fluff, here is an example of the data and what I am trying to do:

Completed Target Allocated Completed Target Allocated Completed Target Allocated 4 4.4 4 4 2.4 4 3 4.4 3 <colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody>

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

So every time the target is 4.4 I want to know what the combined completed number is i.e in this example it would be 7

 

[Fluff]

In that case, what about

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K
1	Completed	Target	Allocated	Completed	Target	Allocated	Completed	Target	Allocated		4.4
2	4	4.4	4	4	2.4	4	3	4.4	3		7
Color

Cell Formulas
Range	Formula
K2	=SUMIF(B2:I2,K1,A2:H2)

 

[DaithiB]

That worked perfectly, thanks a lot for the help

 

[Fluff]

You're welcome