Need formula to calculate Average of Quantity/Order

[onncheng07]

Hi all,


Can I have the formula to calculate the average of order / quantity. The sample as follow:


thanks

onncheng

 

[bobhc]

quote"The sample as follow:"....?????

 

[onncheng07]

Sorry forgot to attached the link for the file.


https://www.dropbox.com/s/e3fz7hv9vqf0hts/Book2.xlsx


thanks

 

[Debraj]

@ Forum..


If someone willing to work in

* a protected file use below password to un-protect sheet..

3b3b3b1b3b5b5

* then.. if someone able to decode below formula..


=SUMIF('G:Excelidea (ori)QuickBooks_Excel_Dashboard_for_monthly_sales_report[QuickBooks_Excel_Dashboard_for_monthly_customer_and_item_sales_report.xls]January'!$D$1:$D$65536,">0",'G:Excelidea (ori)QuickBooks_Excel_Dashboard_for_monthly_sales_report[QuickBooks_Excel_Dashboard_for_monthly_customer_and_item_sales_report.xls]January'!$R$1:$R$65536)

without viewing the file..


GOOD LUCK..


By the way.. dashboard is really cool..


Regards,

Deb