Results 1 to 5 of 5

Excel 2007 : Lookup word and sum and values

Threaded View

  1. #1
    Registered User
    Join Date
    07-07-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question Lookup word and sum and values

    I am trying to make a budget where I have a sheet of my source data, basically a list of the date, category, and amount of all my expenses. In another sheet I have make a budget of what I want to spend with the exact replica next to it except I want to have the number of what I actually spend in each category. So heres my problem... I want to write a formula that is very similar to a vlookup where I can say every time the word "lunch" comes up in my source data go one cell over and put the amount into my budget. However, as Im sure you can imagine I eat lunch everyday and there for do NOT have unique IDs for all my inputs. So I guess what I real want is a type of lookup where it finds every time the word "Lunch" shows up and sums them for a total amount spend on Lunch in my budget. Can anyone think of an easy way to do this. Thanks guys.
    ""
    Last edited by Excel Question; 07-07-2012 at 10:56 PM. Reason: Inappropriate title

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1