Average with condition
There is a problem with average for some specific value in a table. 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.
How to do average for specific items (London, Prague and Paris)?
Solution for Excel 2007
For version 2007 is very easy to calculate this. Just use AVERAGEIF function. So, for London is formula like this:
If you need to copy this to Prague and Paris, you have to fill $ character into the formula. Be careful, $ isn’t in each argument.
Solution for Excel 2003
In version 2003 is AVERAGEIF function missing. Therefore we have to use array formula:
As in the previous example, If you need to copy this to Prague and Paris, you have to fill $ character into the formula.