PFA for Sample data. In that Red color marked is what i need achieve .
IF Amount 2 > = 0 Then show Max of c + Max(Amount 3) (Total using Sum) Else Show Max(Amount 3) (Total using Sum) END.
Please kindly adivice how to sum 2 totals across cell (only totals) not values . i need to capture the total values and sum up in grand total row. please look into the spread sheet for example.
|Name||Set off||Amount 2||Amount 3||Total Limit|
|Total||Max of c||Blank|
|Grand Total||Max of c||80||80+ max of c)|