Hi, 

I am using AVERAGEIF to get a specific average in a particular group but I kept getting the error #DIV/0! using the excel application. But each time I use the excel browser, I get the outcome with no issue.  Can anyone help me with this?

This photo is from browser. 

This is from the excel application. 

​Hi, I am using AVERAGEIF to get a specific average in a particular group but I kept getting the error #DIV/0! using the excel application. But each time I use the excel browser, I get the outcome with no issue.  Can anyone help me with this?This photo is from browser. This is from the excel application.     Read More

​