Statistics on Alternate Columns

[SDruley]

I have the following data matrix:

What formula can I use in cell J1 that will take the standard deviation of only columns A, C, E, G?

Given: The actual matrix is 1,000 columns wide

[Palmetto]

It might be best to simply write a macro to extract the value to another sheet so as to avoid an array formula, however, you might adapt this if you don't want to use VBA.

{=AVERAGE(IF(MOD(COLUMN(A1:H1),2)=1,A1:H1))}

Remember: array formulas are committed using Ctrl + Shift + Enter

If you need every other column starting with column-B, just change =1 to =0

[SDruley]

Nice work.
It is truly amazing that Excel Forum contributors can come up with this amazing stuff!!!