I have written a formula that will take what is written in Column A of my Cover sheet and match it to Column A of all the other worksheets (other worksheets defined as "CMM_Dates") which will inturn take the Column E values of all the CMM_Dates worksheets with a match in Column A and average them.
=SUMPRODUCT(SUMIF(INDIRECT("'"&CMM_Dates&"'!$A:$A"), $A2, INDIRECT("'"&CMM_Dates&"'!$E:$E"))) / (COUNTIF(CMM_Dates,"*"))
MY QUESTION:
Can I take this Equation, and instead of averaging the values taken from Column E of the CMM_Dates Worksheets, can someone help me ReWrite the formula to take a Stand Deviation of the values taken from Column E of the CMM_Dates Worksheets?
=SUMPRODUCT(SUMIF(INDIRECT("'"&CMM_Dates&"'!$A:$A"), $A2, INDIRECT("'"&CMM_Dates&"'!$E:$E"))) / (COUNTIF(CMM_Dates,"*"))
MY QUESTION:
Can I take this Equation, and instead of averaging the values taken from Column E of the CMM_Dates Worksheets, can someone help me ReWrite the formula to take a Stand Deviation of the values taken from Column E of the CMM_Dates Worksheets?
