Clever Geek Handbook

Excel: calculating values ​​by date

I have collected a lot of data over different days. I collected several values ​​for each day.

I would like to calculate the average, SD, min and max for each day. I have included a picture of the layout to illustrate the problem.

Does anyone have a solution? I was able to calculate the average for each day, but only because there is an AVERAGEIFS function. Unfortunately, there is no IFS function for other parameters.

I tried to make vba command, but I am really new to it. Help is greatly appreciated :)

enter image description here

+3


source to share


1 answer


I would use these three formulas:

=STDEV(IF(A:A=criteria,B:B))  'confirmed with ctrl+shift+enter
=MIN(IF(A:A=criteria,B:B))    'confirmed with ctrl+shift+enter
=MAX(IF(A:A=criteria,B:B))    'confirmed with ctrl+shift+enter


where the criterion is a specified date cell such as E9

These are basically replacements for STDEVIF, MINIF, MAXIF as they don't exist on their own.

+3


source






More articles:


All Articles