Based on two factors, I would like the average of Column B. that it occurred the previous year and text requirements from another column. by year, the average For testing purposes, I've included a Year column in the example, but I don't want to add it to every datasheet.
=AVERAGEIFS(Table1[Unit], Table1[Date], "="&YEAR(TODAY())-1, Table1[Text], "Up")
Throws a DIV/0 error.
I believe I need to define the Date range by year.. like (YEAR(Table1[Date]) but it doesn't work.
=AVERAGEIFS(Table1[Unit], (YEAR(Table1[Date]), "="&YEAR(TODAY())-1, Table1[Text], "Up")
I can get an IF statement to work on a single cell but is there is way to get this to work in a column?