TaDecide.xls

I have attached a file and would appreciate any help that I can get.

I was told to use this formula =SUMIF(OFFSET(A1, 1, MATCH("Sector", 1:1, 0)-1, 3000), "Public", INDIRECT(L2:L&"Public"+1))/COUNTIF(OFFSET(A1,1,MATCH("Sector", 1:1, 0)-1, 3000), "Public")


I have uploaded the file with which I am working (though i need to do it on multiple files). Could you please help me find the Sector (G), and sum column L if the value in sector is "public"?

Thank you very much for any help that you can provide