offset

[Rick]

I want to find the word Total located in column A, the word total will move
but does stay in A, and return the total value located in column B next to
the word Total.

 

[Peo Sjoblom]

=VLOOKUP("Total",A:B,2,0)


--


Regards,


Peo Sjoblom

 

[Teethless mama]

=SUMIF(A:A,"Total",B:B)

 

[Max]

I want to find the word Total located in column A, the word total will move
but does stay in A, and return the total value located in column B next to
the word Total.

Eyeing the hint in your subject line,
an alternative* play using OFFSET
In C1: =OFFSET(B1,MATCH("Total",A:A,0)-1,)

*but not necessarily better