![]() ![]() Below are some of the types of problems that can be solved with modifications to the Excel SUM function.Įach function is a topic in its own right but is briefly explained here. Or the reverse - exclude certain values from a total. Sometimes there are special sum-type functions we’d like to perform - like only add cells that satisfy certain criteria. The SUM formula above therefore sees SUM(100, 200, 0, 100, 0, 0, 100) and returns a result of 500. Excel interprets this array formula as an instruction to evaluate each cell within the range one by one, then find the sum of the values within the range. Pressing Control + Shift + Enter creates an array formula (sometimes called CSE formula), denoted by the automatically-inserted curly brackets. Note that you should not type the curly brackets yourself.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |