jeudi 23 juin 2016

Average certain cells based on criteria

my excel sheet

Basically I want to lump all strikes together by certain delta ranges and average them. I am trying to do this in the V5:X19 area.

So in cell X6 I would like the formula to say "Average of all strikes widths(column G) in-between -3 and -1.1." and for it to copy down to average all widths with delta between -1.1 and -0.55, -0.55 and -0.25, ect.

Can anyone help?

Aucun commentaire:

Enregistrer un commentaire