Average value that divides by the amount of months entered.

[scubakerny]

If I add a value into C15 it will populate a value in K15 (I’ve got this part down). In K17 it will total the “Sales for Goal/Hour” but now I want it to divide by the amount of values I put into the C column (the amounts of months entered, so if Sept divide by 9, Oct divide by 10, etc).

For some reason I can not add an attachment

Book1.png

[scubakerny]

=SUMIF(B5:B16,"<>",K5:K16)/10 *This is the formula in K17 where I want the 10 to change to 11 when I enter a value for November

[kersplash]

If your data is in a table then you could just add a total row and select the average option.

To upload an attachment;

Go Advanced -> Manage Attachments -> Upload

[Bo_Ry]

Please try

=AVERAGEIF(K5:K16,">0")

[scubakerny]

Here is the file.

[scubakerny]

I tried the formula =AVERAGEIF(K5:K16,">0") but was not getting what I was looking for.

[Bo_Ry]

Sorry I have no idea what you want.

Please mock up manual result that you what for each cases.

[scubakerny]

Here is the formula that got me what I needed. =SUM(N6:N18)/COUNT(N6:N18)

THANK YOU for your help.

Anthony

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.