Albedo is the first NPC to speak to Momonga when the Great Tomb of Nazarick is transported to the New World. Confused at his strange behavior, Albedo asks if he required anything of her. Ainz orders her to assemble the floor guardian at the six floor. She and along with Demiurge are the last floor guardians to arrived.
Formula: =COUNT(A1:A10) The count formula counts the number of cells in a range that have numbers in them. This formula only works with numbers though: It only counts the cells where there are numbers. **Learn more about the COUNT function in this on-demand, online course.
Column A uses the formula, =(A2+A3+A4+A5)/4, to find the average. Be careful when choosing AVERAGEIF() because it ignores empty cells and that might not be what you want either. If you need a formula that that doesn't ignore empty cells or if you're still using Excel 2003, you can use a formula in the following form: