Search code examples
excelif-statementaveragecriteria

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.

I want to average all values in column G based of what is in column C given the same row

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(column C) between -1.1 and -0.55, -0.55 and -0.25, ect.

Can anyone help?

Solution

  • Try this(untested) in cell X6.

    =averageifs(G:G,C:C,">="&V6,C:C,"<"&V7)