Forum Discussion

Copper Contributor

Feb 16, 2018

How do I reference a range of cells using a function?

I am trying to use a formula where a function will return a cell reference to then use in another function of the same cell. The formula that I am trying to use is =average(vlookup(K9,A:B,2,false):v...

Formulas & Functions

Need Help

JKPieterse

Silver Contributor

Check out the AVERAGEIFS function. Suppose your min and max dates are in F1 and F2:
=AVERAGEIFS($B$2:$B$100,$A$2:$A$100,"<="&$F$1,$A$2:$A$100,">="&$F$2)

Kurt Turley

Copper Contributor

Feb 16, 2018

Thank you. I just had to switch the lesser than/equal and greater than/equal symbols and it worked.