This example shows you how to solve a system of linear equations in Excel. For example, we have the following system of linear equations: If A-1 (the inverse of A) exists, we can multiply both sides by A-1 to obtain X = A-1B. To solve this system of linear equations in Excel, execute the following […]
This example teaches you how to find the most frequently occurring word in Excel. You can use the MODE function to find the most frequently occurring number. However, the MODE function only works with numbers. You can use the COUNTIF function to count the number of occurrences of each word. However, we are looking for […]
This example teaches you how to perform a two-column lookup in Excel. See the example below. We want to look up the salary of James Clark, not James Smith, not James Anderson. 1. To join strings, use the & operator. 2. The MATCH function returns the position of a value in a given range. Insert […]
Summing with Or criteria in Excel can be tricky. This article shows several easy to follow examples. 1. We start simple. For example, we want to sum the cells that meet the following criteria: Google or Facebook (one criteria range). 2a. However, if we want to sum the cells that meet the following criteria: Google […]
This example shows you how to create an array formula that sums a range with errors. You can also use the AGGREGATE function to sum a range with errors. 1. We use the IFERROR function to check for an error. Explanation: the IFERROR function returns 0, if an error is found. If not, it returns […]
This example shows you how to create an array formula that sums the largest numbers in a range. 1. We use the LARGE function. For example, to find the second to largest number, use the following function. 2. To sum the 4 largest numbers (don’t be overwhelmed), add the SUM function and replace 2 with […]
This example shows you how to create an array formula that sums every nth row in Excel. We will show it for n = 3, but you can do this for any number. 1. The ROW function returns the row number of a cell. 2. The MOD function gives the remainder of a division. For […]
