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