Check the SUMIF function instead of lookup. The general format is
=sumif(where to look, what to look for, what to add when matching). So if
you want to find "SAVINGS" in sheet1 column C and add up all the
corresponding values in sheet1 column B, it would be
=sumif(Sheet1!C:C,"SAVINGS",Sheet1!B:B). You can change sheet names and
columns as needed, and add up the results of 12 such sumif's to capture all
12 months.
You can also limit the ranges to specific rows
(Sheet1!$C$1:$C$C20,"SAVINGS",Sheet1!$B$1:$B$20). But unless you have other
data in those columns that could get inadvertently added in, I find it easier
to use entire columns; it also avoids the problem adding rows that extend
beyond the range used in the sumif function.
HTH. --Bruce

"CheriT63" wrote:

I am trying to create a formula that will allow me to look at multiple
spreadsheets, find text and sum all values it finds.

I have a budget set up on 12 spreadsheets from Jan to Dec. I am looking for
a formula that will allow me to lookup anywhere I have input SAVINGS and sum
the amounts listed in the subsequent column where I have input the savings
amount for that week.

Help!

Cheri