SUMIF equation for a range outcome - want to add values from another column.

[rixcel]

Hi all,

I am currently using the following equation which works fine:

=SUMIF(OUTCOME!$H$4:$H$250,B191,OUTCOME!$L$4:$L$250)

I now want to add a second column (K) of values from the same reference page (OUTCOME), i tried to change the formula to:

=SUMIF(OUTCOME!$H$4:$H$250'+!$K$4:$K$250,B189,OUTCOME!$L$4:$L$250'+!$K$4:$K$250)

....it doesn't work.

Any ideas please?

 

[Toadstool]

Hi Rixcel,
Is this what you want?

Rixcel.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
187								Bert			11	1
188								Fred			22	2
189	84	Bert						Fred			33	3
190								Fred			44	4
191								Fred			55	5
192								Bert			66	6
OUTCOME

Cell Formulas
Range	Formula
A189	A189	=SUMIF(OUTCOME!$H$4:$H$250,B189,OUTCOME!$L$4:$L$250)+SUMIF(OUTCOME!$H$4:$H$250,B189,OUTCOME!$K$4:$K$250)

 

[rixcel]

Hi Rixcel,
Is this what you want?

Rixcel.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
187								Bert			11	1
188								Fred			22	2
189	84	Bert						Fred			33	3
190								Fred			44	4
191								Fred			55	5
192								Bert			66	6
OUTCOME

Cell Formulas
Range	Formula
A189	A189	=SUMIF(OUTCOME!$H$4:$H$250,B189,OUTCOME!$L$4:$L$250)+SUMIF(OUTCOME!$H$4:$H$250,B189,OUTCOME!$K$4:$K$250)

Perfect - Thank you so much