Hi Jaime,

Am Wed, 13 Jan 2016 11:38:56 -0800 (PST) schrieb
:

Example:
Col B Col J
57 (60C) 5
61 (60C) 3
62 (60C) 2
63 (60C) 2
70 (60C) 4

Every time after the last 60C on column b there a "Service Area Total" word
5 Rows below that and the total that I need is on col j or 9 col over to the right

your explanation is not really clear but I hope I understood it
correctly.
Try:
=INDIRECT("J"&MATCH("*"&"(60C)",B:B,-1)+5)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional