This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I tried following this article:
step‐for‐step and everything was going perferctly until I got to this part:
I copied and pasted the formula from the help article straight into a blank cell in my worksheet, just like I did with all the other formulae from the same article, and it returned a #VALUE! error. What am I missing? This ability would be extremely useful on some of the sheets I work with on a daily basis.
Thank you.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
These columns are separate range just for refer to, you should add calculation on it.
Here is example.
=HSTACK(DeptSales[Sales Amount],DeptSales[Commission Amount])
Amazing! That does it perfectly. Please make sure that the article I linked to in my OP gets updated to reflect this. Iʼve seen other people complaining about it also.
Thank you!
Dear KenSamuel Kyllingmark,
Thank you for posting to Microsoft Community. We are glad to assist. We are looking into your situation and we will update the thread shortly.
Appreciate your patience and understanding and thank you for your time and cooperation.
Sincerely,
Hailey