Results 1 to 10 of 10

If Statement to accumulate an amount in a cell

Threaded View

  1. #1
    Registered User
    Join Date
    08-21-2009
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    48

    If Statement to accumulate an amount in a cell

    Hi All, I hate IF statements I know what I want from them can just never work it out!!!!!

    So in a cell I have a description, say "FOOD" then another cell with amount say £2, then in another cell I want it to be looking and if it sees "FOOD" entered, it takes the amount £2 and adds it to a running balance.

    Cell A1 = Food
    Cell B1 = £2

    Cell H1 = (looks and if Food) adds £2 to cell

    Can it be done?

    Thanks
    Last edited by tazmanian24; 09-11-2009 at 02:26 AM.

Thread Information

Users Browsing this Thread

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

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