Hi,
I used AverageIf for my data, I am looking for a function that works like AVERAGEIF but instead of average, calculating Variance.
Here is how I use it :
=AVERAGEIF(Table1[Shift],"1st",Table1[Time])
If the shift column is "1st" then calculate the average of time.
I've attached the sample of my excel file.
Thank you in advance for helping me.
Bookmarks