I have an Excel table attached with data from study in small animals.


Each line includes nr, gender, code and 3 body weights measured on Day0, D1 and D2.
I like to take averages, counts (n) and stdevs for each code-group and on each Day using named ranges.
However, calculating averages is no problem but for count and stdev there is a problem as I may need to used lookup functions.

Can someone help me with this?
Problem fields are marked in yellow backgound
In the table, right from the original data, the same data or copied and sorted by code to easily calculate above parameters using simple formulas for comfirmation of used formulas.

Thanks in advance
Roland

Attached Files

for forum.xlsx (18.7 KB, 8 views)