Now we’ll use the AVERAGEIF function to determine the average for sales where the number of orders is greater than 50.

The function evaluates how many cells in the Sales column meet the criteria of greater than 60000. The average for sales greater than $60000 is $71229. Excel automatically adds the closing parenthesis to the formula. Excel would interpret that as a separator for arguments of the function and return an error.Īnd press Enter. Type an = sign, AVERAGEIF, opening parenthesis (in this example, we are going to evaluate and average the same range of cells, C2 through C5, in the Sales column), comma, then we type the criteria against which the range is evaluated, enclosed in quotes (you put it in quotes so Excel interprets the operator and value correctly), in this example, greater than 60000.ĭon’t type a comma in 60000. Let’s determine the average for sales that are greater than $60000.

Be careful what you wish for.The AVERAGEIF function returns the average of cells in a range that meet criteria you provide. And if you manage to make it to the final battle without spending wishes, you’ll find yourself in a very advantageous position. If you manage to make it all the way to the heart of The City of Brass, any genies you’ve wished will appear in the final encounter to give you one last chance to change your gear or aid you in the final battle. Spending a wish to upgrade a genie who can bestow health, for instance, will also significantly increase its future cost, making it a considerable loot drain should you need it the further into the game you progress. Wish effects persist across all levels in a single run but there is a trade off. Using these wishes is always beneficial - wishing at a shop genie unlocks more powerful items to buy, while wishing on an enemy genie will turn them to your side. Don't Hoard Your WishesAt the start of every run in City of Brass you’re given three wishes. These safe rooms are devoid of traps and will sometimes hide hidden treasures. It’s also worth pointing out that City of Brass regularly offers players a small respite from the unending onslaught of the city’s residents. Pay attention to the game’s audio as valuable treasure chests sing and can be tracked by following the source of the sound. It’s much safer to only seek out the larger treasures and chests and move on. If you attempt to pick up every piece of loot you see, this will quickly lead to you being overwhelmed by enemies. Every area in the game is littered with collectible treasure, but not all of it is worth your time. “Loot is at the very core of The City of Brass.

City of Brass download the new for mac