Thread: Sum values in multiple sheets using Lookup to find a text match
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CheriT63
 
Posts: n/a
Default Sum values in multiple sheets using Lookup to find a text match
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
Reply With QuoteReply With Quote