Match & Last Row Combined

[pauldaddyadams]

Hi,

I have a summary sheet and I would like it to pull data from the data sheet “South”

What I would like a formula to do is:
Match the word “overall result” in row 3:4
Match the word “Cost” in row 5
Then return the total based on the last row

e.g. on the summary sheet in cell E5 this should return 468291.745 – based on finding column AJ and the Last row

Can anyone help please?

Paul

[Fotis1991]

A simple...way using a helper row with this formula.

=IF(AND(G3="Overall Result",G6="Cost"),INDEX(G7:G1000,MATCH(9.99999999999999E+307,G7:G1000)),"")

and then you get your result using

=SUM(South!G2:AK2)

[pauldaddyadams]

Thanks Fotis - this will work perfectly!