Sum everything above specific cell

[zjabjab]

I want to SUM everything above a cell that contains the word "SUMTOTAL". So if I have 50 columns I want it to go to first row that has the text "SUMTOTAL" in it and then Sum everything aboce that word. Is it possible?

[Moo the Dog]

Modified this post to use a better way... see example attached workbook:

Formula used in example:

=SUM(A1:INDEX(A1:A8,MATCH("SUMTOTAL",A1:A8,0)))