Although looking at the formula's syntax gives us a fair idea of how to use the formula, looking at the formula in action can lift your understanding. Let’s look at a few examples of the SUMIF formula in Google Sheets. Example 1: A Numeric Condition In this example, we have a sampl...
1. The data for each month contains multiple entries for some builders, so I can't simply sum it. 2. You can’t use the SUMIFS function across multiple sheets…well not on its own. Solution 1: The slow option If you’ve got oodles of time and a super computer you could add one ...
The -- in front of the LEFT function is a trick we need to play on Excel to force it to treat the result from the LEFT function as a number rather than a text value. It does this by turning it into a negative number then back again (that's what the -- does). The only way E...