Forum Discussion

Gossemer's avatar
Gossemer
Copper Contributor
Jul 23, 2020

Help with a function in Excel

I'm trying to make a formula that will average a range of cells, but only if those cells are labeled by a specific month ("Jan"). I've tried the if function : =IF(B8:BB8="Jan"),AVERAGE(B9:BB9),"-" ...
excel
Formulas and Functions
office 365
mathetes's avatar
mathetes
Gold Contributor
Jul 23, 2020

Gossemer 

 

If you have the newest version of Excel, you can do this easily with the new Dynamic Array function called FILTER.

 

Here's the formula: =AVERAGE(FILTER(B9:BB9,B8:BB8="Jan"))

 

 

 

 

Resources