Averageifs

Hi guys,

I am trying to get the average total assets for companies with the same year and same SIC code in the AVGIFS-tab. Ultimately, the average of all the "rivals" in an acquisition announcement event should be calculated and added to the master file in which I summarized my data (I shrank this file to the first tab to make it easier).

Could you please help me out with this?

Thanks in advance,

Tim