perla1962
asked on
VLOOKUP Excell 2010
Hi,
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()
=VLOOKUP() + VLOOKUP()
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()
=VLOOKUP() + VLOOKUP()
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ssaqibh, looks like we're the only active Excel experts at the moment :-))
Good day to you, teylyn, or is it already night at your place?
ASKER
I got it Thank you.
ssaqibh, almost midnight. See you around.
can you explain what you want to sum or lookup? Can you post a sample file? That would make it much clearer.
cheers, teylyn