How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask jsterq Your Own Question

jsterq, Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 31
Experience:  I have knowledge in multiple Microsoft products including the entire Office suite (Word, Excel, powerpoint, etc).
Type Your Microsoft Office Question Here...
jsterq is online now
A new question is answered every 9 seconds

RA - 330

Customer Question

This question is in regards XXXXX XXXXX

Can you use cell references in formulas and functions? If so, how? If not, why not?
Submitted: 4 years ago.
Category: Microsoft Office
Expert:  rhess replied 4 years ago.

rhess :

Yes, you can. Give me an idea of what you want to do specifically and I will explain exactly how you can do it.

Customer :

I needed a full response to this yesterday, so I won't be accepting it.

Expert:  jsterq replied 4 years ago.
Absolutely, to make a reference to cell C2 & D3 and get their sum ...type "=sum(C2,D3)" without the quotation marks. Also, if you want to make an absolute cell reference (used when you want a cell reference to stay fixed on a specific cell) you would type "=sum($C$2,$D$3)"

Related Microsoft Office Questions