Forum Discussion
Average Ifs with multiple criteria
Hey gus! I am trying to find the average cost for each category under specific criteria. Inf_Sales_Data!B:B is the month and this should match the current month on the sheet. Inf_Sales_Data!A...
Perhaps
=AVERAGE(IF((Inf_Sales_Data!$A$2:$A$1000=$B$1)*(Inf_Sales_Data!$B$2:$B$1000=$B$2)*(Inf_Sales_Data!$AB$2:$AB$1000=A89)*((Inf_Sales_Data!$T$2:$T$1000="normal")+(Inf_Sales_Data!$T$2:$T$1000="normal 1")+(Inf_Sales_Data!$T$2:$T$1000="normal 2")+(Inf_Sales_Data!$T$2:$T$1000="normal 3")+(Inf_Sales_Data!$T$2:$T$1000="normal 4")+(Inf_Sales_Data!$T$2:$T$1000="normal 5"));Inf_Sales_Data!$J$2:$J$1000))
HansVogelaar
Unfortunately not 😞 It returns a div/0 error, which is not possible since the value shouldent be 0
Unfortunately not 😞 It returns a div/0 error, which is not possible since the value shouldent be 0
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.