VLOOKUP Excell 2010

Posted on 2011-10-29
Last Modified: 2012-06-27
Can you guys help me out I’m lost somewhere  I’m already completed the table; I just need to display the sum of the salary and the bonus, and add the formula on cell C21

 C20       Name      Code      Check Amount
C21       Mary          1      
C22        Sue           3      
C23        Ralph         2      

TOTAL              $                 -  

Table to Compute Sum of Salary and Bonus:
Code      Salary                    Bonus      
1            10,000                         500       
2             5,000                         600       
3             8,000                         400       

I’m trying to use the following functions.
=SUM() + SUM()

Question by:perla1962
    LVL 43

    Accepted Solution

    Try this file

    LVL 50

    Expert Comment


    can you explain what you want to sum or lookup? Can you post a sample file? That would make it much clearer.

    cheers, teylyn
    LVL 17

    Assisted Solution

    Would this help you?


    Open in new window

    Change references as required.

    See sample result.

     Formula Example
    LVL 50

    Expert Comment

    ssaqibh, looks like we're the only active Excel experts at the moment :-))
    LVL 43

    Expert Comment

    by:Saqib Husain, Syed
    Good day to you, teylyn, or is it already night at your place?

    Author Closing Comment

    I got it Thank you.
    LVL 50

    Expert Comment

    ssaqibh, almost midnight. See you around.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now