CODEWITHSUNDEEP
excelworksheet-functionvba
Alex
Alex

Reputation: 57

Excel: Calculating values by date

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

I would like to calculate the mean, SD, min and max for each day. I've included a picture of a mockup, to illustrate the problem.

Does anyone have a solution? I've managed to calculate the average for each day, but only because there's an AVERAGEIFS function. Unfortunately there doesn't exist an IFS function for the other parameters.

I've tried to make a vba command, but I'm really a newbie at it. Help is much appreciated :)

enter image description here

Upvotes: 3

Views: 71

Answers (1)

KFichter
KFichter

Reputation: 783

I would use these three formulae:

=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 criteria is the date cell specified, such as E9

These are basically STDEVIF, MINIF, MAXIF replacements as these do not exist on their own.

Upvotes: 3

Related Questions