Provide the formula

Q3: 10 points

Your manager has given you a table of raw data to perform analysis on. You have been tasked to

find a flexible way to show the average Sales Revenue in different months for different regions.

Use Subtotalalong with the filter to show theaverage sales revenue in March for the south region in cell H5.

Average

Store

Month

Region

Sales Revenue

RSE001

Jan

East

$ 1,690.00

RSE001

Feb

East

$ 1,830.00

RSE001

Mar

East

$ 1,569.00

RSE001

Apr

East

$ 2,046.00

RSE002

Jan

East

$ 1,974.00

RSE002

Feb

East

$ 4,212.00

RSE002

Mar

East

$ 3,256.00

RSE002

Apr

East

$ 3,478.00

RSN001

Jan

North

$ 1,976.00

RSN001

Feb

North

$ 2,109.00

RSN001

Mar

North

$ 1,946.00

RSN001

Apr

North

$ 2,963.00

RSN002

Jan

North

$ 1,922.00

RSN002

Feb

North

$ 1,876.00

RSN002

Mar

North

$ 2,127.00

RSN002

Apr

North

$ 3,365.00

RSS001

Jan

South

$ 2,089.00

RSS001

Feb

South

$ 2,221.00

RSS001

Mar

South

$ 2,082.00

RSS001

Apr

South

$ 1,565.00

RSS002

Jan

South

$ 2,070.00

RSS002

Feb

South

$ 2,089.00

RSS002

Mar

South

$ 1,983.00

RSS002

Apr

South

$ 2,146.00

RSS003

Jan

South

$ 2,120.00

RSS003

Feb

South

$ 1,999.00

RSS003

Mar

South

$ 2,107.00

RSS003

Apr

South

$ 1,782.00

RSS004

Jan

South

$ 1,457.00

RSS004

Feb

South

$ 1,560.00

RSS004

Mar

South

$ 2,136.00

RSS004

Apr

South

$ 1,956.00

RSW001

Jan

West

$ 1,880.00

RSW001

Feb

West

$ 2,135.00

RSW001

Mar

West

$ 2,728.00

RSW001

Apr

West

$ 2,024.00

RSW002

Jan

West

$ 1,993.00

RSW002

Feb

West

$ 1,289.00

RSW002

Mar

West

$ 1,649.00

RSW002

Apr

West

$ 2,003.00

RSW003

Jan

West

$ 1,882.00

RSW003

Feb

West

$ 2,760.00

RSW003

Mar

West

$ 2,249.00

RSW003

Apr

West

$ 4,863.00