Standar deviation across sheets help

I

ibressler

I have written a formula that will take what is written in Column A o
my Cover sheet and match it to Column A of all the other worksheet
(other worksheets defined as "CMM_Dates") which will in turn take th
Column E values of all the CMM_Dates worksheets (with a match in Colum
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 fro
Column E of the CMM_Dates Worksheets, can you help me ReWrite th
formula to take a Stand Deviation of the values taken from Column E o
the CMM_Dates Worksheets?

Any help would be greatly appreciated

Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding multiple values from matched search results 3
series of formulas to get to one formula 0
Standard Deviation and Averages based on criteria 2
Getting a formula to reflect added columns 10
COUNTIFS BETWEEN WORKSHEETS HELP 1
Multiple VLOOKUP in an IF statement 2
Can the IF function be used with values from multiple worksheets? 4
Need urgent help with Excel formula 1

Top