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.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks