Standard Deviation with Dynamic Range

[madaboutgolf]

Good morning! How can I change the following to accommodate dynamic ranges in columns A and G?

=STDEV(if(G1:G21<>”Wednesday”,A1:A21))

Entered as an array formula.

Thanks in advance for your help.

[madaboutgolf]

Never mind. I figured out how to use the Indirect function to solve my problem. It seems the answer often comes to me five minutes after I post.