There is problem with average for some specific values in a table. We need to make average of the items that meet several criteria. Following table represents data of some worldwide company. You can see branch offices in the cities and number of their new customers per each month and year.

 How to do average of specific branch offices for specific year? Continue reading “Average with multiple conditions” »