Getting a #div/0! error using =AVERAGEIF

Hello,

I am using excel to track inventory for a small business. I am building out a few pages for each category of inputs and have a sheet dedicated to collecting the usage/month that pulls the sums from the input specific sheets. On my dashboard page (which houses current levels, and other high level information) I want to have a cell that averages the historic monthly demand. Due to the way the monthly sums are set up I have it looking for information from January to December, however as it is only February, there are 10 months that have 0 in the current monthly demand.

Because of this, I am using the formula =AVERAGEIF('Month Sums'!B2:B13,">0",'Month Sums'!B2:B13). Where Month Sums is the sheet where the month sums is, B2:B13 is the monthly Sum of product usage (those cells consist of the formula =SUMIF('Coffee Beans'!$D:$D,month number,'Coffee Beans'!$B:$C) ). So i want to have the average of all the non 0 numbers from the monthly sums page.

However I am recieveing a #div/0! error on the averageif formula. is this because i have it averaging a formula rather than a number?

Thanks

Thanks for getting back to be Special-K

The values in b:12:B13 are bellow

880.00
300.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

I would like the formula to average January (880) and Febrauary (300) and then add in March once it has information.

The 880 is populated by the formula =SUMIF('Coffee Beans'!$D:$D,1,'Coffee Beans'!$B:$C)
300 by =SUMIF('Coffee Beans'!$D:$D,2,'Coffee Beans'!$B:$C)

This led to my development of the =AVERAGEIF('Month Sums'!B2:B13,">0",'Month Sums'!B2:B13) formula in the hopes that it would average the non zero numbers.

Can I not set the criteria range the same as the average range?

The average if formula is on the Dashboard tab. The Sum formula is on the monthly sum sheet.

Inventory for help.xlsx

I am on a mac, and am not seeing the formula tab that says evaluate formula

I am glad to know that the formula is built correctly!

So i wonder if it is a mac thing. I have included a screenshot so you know I am not crazy!Screen shot 2016-02-05 at 1.49.15 PM.png

Correct, Double clicking and then hitting enter still results in an error

Thanks John.

I uploaded it to a google sheet and it works great!!!!

Thanks for all of the help, and I appreciate all of the insights I was given.

Ben