Hi
I am having trouble with the below formula. The formula returns #value . I'm hoping someone can spot something that I can't see.
=SUMIFS(((INDEX('Cash Flow items'!$C$4:$J$5,MATCH('Outflow Summary'!$B4,'Cash Flow items'!$B$4:$B$5,0),MATCH('Outflow Summary'!$C4,'Cash Flow items'!$C$3:$J$3,0)))),'Cash Flow items'!$A$4:$A$5,'Outflow Summary'!$F$2)
I have run an index formula and sumif formula with success however no success when combining the 2.
I am having trouble with the below formula. The formula returns #value . I'm hoping someone can spot something that I can't see.
=SUMIFS(((INDEX('Cash Flow items'!$C$4:$J$5,MATCH('Outflow Summary'!$B4,'Cash Flow items'!$B$4:$B$5,0),MATCH('Outflow Summary'!$C4,'Cash Flow items'!$C$3:$J$3,0)))),'Cash Flow items'!$A$4:$A$5,'Outflow Summary'!$F$2)
I have run an index formula and sumif formula with success however no success when combining the 2.