• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 184
  • Last Modified:

SUM vlookup

On the attached sheet I need to SUM AR34 + AT34. I then need to copy the formula down for the rest of the values in column AR?

Rob
THS-DIRECT-supplier-database.xlsx
0
robmarr700
Asked:
robmarr700
  • 3
1 Solution
 
Rob HensonFinance AnalystCommented:
Where are you wanting the sum?

Simple formula:

=SUM(AR34,AT34)

Copy down as required.

As I have just learnt in another question, =AR34+AT34 will not work if one or other is text but the SUM option will.

What seems to be the problem beyond the simple formula?

Thanks
Rob H
0
 
robmarr700Author Commented:
I want the value to be returned in column AR?
0
 
Rob HensonFinance AnalystCommented:
You will get circular reference. You cannot include the value of a cell within a formula in the same cell.
0
 
Rob HensonFinance AnalystCommented:
As column AT has a formula, you can just include the value of AR in that formula; you end up with result in AT instead though.

=AR34+VLOOKUP(...)

Thanks
Rob H
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now