I'd like to calculate the average spending on given categories but not all. I use
AVERAGEIFS for this. But it doesn't seem to work.
My sheet (just relevant columns):
B | D Spent|Category -----|--------- 10 |Category1 11 |Category1 9 |Category6 30 |Category3 22 |Category4 15 |Category5
I have this formula:
And it always gives me
#DIV/0! Even when I have at least one value in all category. Based on the documentation I either do this right or I fail to see the error in my ways.