Forum Discussion

Jack Glass's avatar
Jack Glass
Copper Contributor
Aug 06, 2018
Solved

Excel Sum

Hello all   I would like to sum the total of a column but display the total at the top of the column instead of the bottom as shown in the picture.  I want to start with the number shown in the top...
  • SergeiBaklan's avatar
    Aug 06, 2018

    Hi Jack,

     

    If your "blue" 990 is in B3 you may use for B3 something like

    =990+SUM(B4:B100)

    or which range you have. If B3 is variable, you may change them in a helper sheet and use

    =Sheet2!B3+SUM(B4:B100)