Complex IF Statement

I need help writing an IF statement with the following characteristics. The formula should be in AA72 on the Live Trades Worksheet. Help with this would begreatly appreciated!



If A62="Short" then AA67 - perform this following division calculation for every Ticker in the range C71:C90 and sum the results for each Ticker together ((Dividend value on Corporate Action Sheet Column G/Last Price on Live Trades Sheet Column D))/counta(C71:C90)

ADD the result above to the result of the statement below

Perform this following division calculation for every Ticker in the range C59:C68 and sum the results for each Ticker together ((Dividend value on Corporate Action Sheet Column G/Last Price on Live Trades Sheet Colum D))/counta(C59:C68)


If A62="Long" then AA67 + perform this following division calculation for every Ticker in the range C71:C90 and sum the results for each Ticker together ((Dividend value on Corporate Action Sheet Column G/Last Price on Live Trades Sheet))/counta(C71:C90)

Subtract the results above to the results of the statement below

Perform this following division calculation for every Ticker in the range C59:C68 and sum the results for each Ticker together ((Dividend value on Corporate Action Sheet Column G/Last Price on Live Trades Sheet Colum D))/counta(C59:C68)

Can anyone help me with this please?