+ Reply to Thread
Results 1 to 2 of 2

Add numbers if adjacent column meets criteria

  1. #1
    Registered User
    Join Date
    03-17-2008
    Posts
    7

    Add numbers if adjacent column meets criteria

    I know there is a simple way to complete the computation I am looking for, but for some reason I can't seem to come up with a solution. I need to be able to calculate the totals for each of the food types.

    A B C D
    1 Pizza 10
    2 Hamburger 5
    3 Fries 2
    4 Fries 2
    5 Pizza 10
    6 Hamburger 5


    Total Pizza:

    So basically I need formula that can search column A and find all the pizzas, then add the corresponding values in column D. So the right total for this example would be 20.

    Thanks for the help

  2. #2
    Registered User
    Join Date
    03-17-2008
    Posts
    7
    Ah ha...SUMIF

+ Reply to Thread

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