Help required in entering correct formula

Hi all,

 

I need help in entering a correct formula based on calculations involved in another sheet. Let me begin with the sheet containing the calculations. 

 

I have some companies and what is listed is their share price as on a particular date and the no. of shares next to it. It is multiplied to get Share Market Value(Column E). In the next column is contained Book value for these shares. If Share Market Value>book value, there is unrealized appreciation. If Share Market Value<book value, there is unrealized depreciation.  The value of the difference between Share Market Value and book value gives the unrealized appreciation/depreciation. In column G, in case of appreciation, 50% of the (Share Market Value-Book Value) is calculated. In case of depreciation, the full value of (Book Value-Share Market Value) is calculated and put in Column G. 

In case you are not able to see the formula for cells in Column G in the screenshot, it is 

=IF(E14>F14, ((E14-F14)/2), (F14-E14)). The TOTAL UNREALIZED APPRECIATION/DEPRECIATION is calculated by doing a summation of cells above it in Column G. 

Till now, it is all right. Now, in the next sheet(Screenshot given below)

Please focus on rows 3 and 6. In case of unrealized appreciation,which happens when (Share Market Value-Book Value) >0, I want the TOTAL UNREALIZED APPRECIATION/DEPRECIATION value to come to come to row 3 and row 6 should be zero. In case of unrealized depreciation, which happens when (Book Value-Share Market Value)>0, I want TOTAL UNREALIZED APPRECIATION/DEPRECIATION value to come to row 6 and row 3 to have value 0.

Can anybody help me in putting correct formula in row 3 and 6?    

I entered the following formula for row 3 but it is showing error message.

 

=IF('Unrealized Appr or Dep.'!(SUM('Unrealized Appr or Dep.'!E14:E23)>SUM('Unrealized Appr or Dep.'!F14:F23))," 'Unrealized Appr or Dep.'!G24","0")