Question

Enter a function using 3-D references and grouped worksheets to total the Q1 walkup sales from the Idaho through Washington worksheets.

Answer 1

To total the Q1 walkup sales from the Idaho through Washington worksheets using 3-D references and grouped worksheets, you can use the SUM function.

Step-by-step explanation:

To total the Q1 walkup sales from the Idaho through Washington worksheets using 3-D references and grouped worksheets, you can use the SUM function.

Let's assume that the worksheets for each state are named 'Idaho', 'Oregon', and 'Washington'. To sum the walkup sales from Q1, you can use the following formula:

=SUM('Idaho:Washington'!Q1)

This formula will sum the Q1 walkup sales from all the worksheets between 'Idaho' and 'Washington', inclusive.