The data array that I am working on is massive, containing 25 columns and
several thousand rows. I need to calculate the stdev for data that is
distributed across 5 columns for around 400 different variables, that are
specified by 2 criteria. THe DSTDEV function only does this for 1 column at a
time, and averaging stdevs across columns does not return the proper value. I
have tried other conditional formulas, combinations of IF & AND functions,
but these have not managed to isolate the data I want. Doing it manually
would take several days, so could you please advise me which combinations of
excel formulas, if any, might work?

"FLKulchar" wrote:

I use the STDEV function...it ignores blank cells, for example in addition,
you must use other Excel formulas to stipulate your parameters within the
=STDEV formula.

See the Help Menu (STDEV) in any Excel workbook.

Regards,FLKulchar
"Rex_Tucker" wrote in message
...
Hi guys,

I've got a dilly of a pickle, I need to calculate the stdev across data
from
multiple fields for data that match certain criteria. Calculating the
average
across multiple fields is no problem, as the average for each field can be
added then divided by the total number of fields. However the stdev cannot
be
calculated this way. There is no information I can find on how this might
be
easily achieved using some variation of the DSTDEV function. Any ideas?