Hi, Using Excel 2007 I'm trying to use the AVERAGEIFS function to average a column based on multiple criteria, but it keeps returning #DIV error which I don't understand.
For example, with this basic data:
data.jpg
I want to find the average of column B where A is Apple or Orange, which should be the first 8 rows averaging 4.5.
But using this formula, I get #Div
Formula:Please Login or Register to view this content.
Any idea what I'm doing wrong?
Bookmarks