1) Current formula (embedded in a text box): =ASVIEW!$AR$9

- I need to update this formula to SUM all values from AR9 through AR16. How would I go about updating this formula?

2) In Excel, is there a way to prevent multiple selections from a slicer? If not, are there any alternatives? Ideally, the user can select only one option, but I don't know of a better way to allow for a single selection from the slicer.

3) Need to write a formula to output the value found for the below scenario in Sheet3, A1:

If Sheet1 (Column A10) is = "ABC" THEN VLOOKUP TO Sheet2 -> Column W to find "ABC".

When "ABC" is matched, output the value found in Sheet2, Column X into Sheet3.