Forum Discussion

WishIWerentAN00b's avatar
WishIWerentAN00b
Copper Contributor
Sep 01, 2022

Averageifs (the average for the past 3 months)

=averageifs(Inf_Sales_Data!P:P,Inf_Sales_Data!B:B,{$G$216,$H$216,$I$216},Inf_Sales_Data!T:T,{"Feedpost","Reel","Short","Short 2"})   My question is whether the syntax of this formula is correct. I ...
excel
Formulas and Functions
brunomerola's avatar
brunomerola
Brass Contributor
Sep 01, 2022

WishIWerentAN00b 

 

That should work:

=LET(
  crit,--(ISNUMBER(XMATCH(Inf_Sales_Data!B:B,{$G$216,$H$216,$I$216}))+ISNUMBER(XMATCH(Inf_Sales_Data!T:T,{"Feedpost","Reel","Short","Short 2"}))>=1),
  IFNA(SUM(crit*Inf_Sales_Data!P:P)/SUM(crit),0)
)

 

Resources