Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Standar deviation across sheets help
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 in turn 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 you help me ReWrite the formula to take a Stand Deviation of the values taken from Column E of the CMM_Dates Worksheets? Any help would be greatly appreciated Thank you, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Standard Deviation | Excel Worksheet Functions | |||
Excel Standar Colour Palette | Excel Discussion (Misc queries) | |||
Standard Deviation | Excel Worksheet Functions | |||
How working with Access Databases through Excel 2003 Standar Editi | Excel Programming | |||
how do I setup an excel table that outlines the face of a standar. | Excel Discussion (Misc queries) |