Suggested new Excel function: SUMABOVE(Ref)

Ref = Single cell reference in the same column as the function. The function
automatically adds all values from REF through the cell preceding the
function [if D4 = SUMABOVE(D1), the formula sums D1:D3]. This eliminates
issues of inserting rows immediately above the formula row and having to
adjust the formula to include them. Can also work similar to SUBTOTAL
function, where overlapping SUMABOVE functions do not duplicate the amounts
added.

Alternatively, REF can be in a different column and a block will be added,
i.e., if D4 = SUMABOVE(A1), the result is SUM(A1:D3).

Similarly: SUMLEFT, SUMRIGHT, SUMDOWN


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions