| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating values across multiple fields for DSTDEV
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Fields In Multiple Ranged Pivot Table | Excel Discussion (Misc queries) | |||
| Logically Calculating Multiple Fields | Excel Discussion (Misc queries) | |||
| Calculating values from multiplesheets with multiple criteria | Excel Worksheet Functions | |||
| Calculating fields in pivot tables | Excel Discussion (Misc queries) | |||
| Values of ComboBox fields and SQL | Excel Discussion (Misc queries) | |||
Threaded Mode
