Excel Tips, Tricks, and Shortcuts

Concept: To set up formula of AVERAGEIF into the cell to auto calculate the average sales amount for the whole year while update data in every month (Year To Date). Syntax of AVERAGEIF formula function: =AVERAGEIF (range, criteria, average_range) Range: Required (Must fill out). One or more cells to average, including data entered such as arrays, numbers, names, or references that contain numbers. Criteria: Required (Must fill out). The criteria in the form of a cell reference, number(s), expression, or text that defines which cells are averaged. For example, criteria can be expressed as 123, "123", "<>123", ">123", "Student", "BlogMaster" or A1. Average_range: Optional (Non-compulsory). The actual set of cells to average. If it’s omitted, range is used. Example: In column, B2-E2 they have been being felt the sales amount as: B2 = 200, C2 = 230, D2 = 252, E2 = 232 In column F2-M2 are empty. In co...