Excel For Farmers: The Sumif Formula
Spreadsheets are awesome for farm financial analysis!
This is a bit ironic coming from a company that’s dedicated to helping farmers via a set of non-spreadsheet software tools. But spreadsheets are hard to beat for many types of simple analysis.
The sumif formula is a great example of a cool and useful spreadsheet feature. This formula is great for analysis where you want to sum a list of specific quantities. For example, you can quickly sum the amount of acres you have planted to a each crop or the total amount of a specifc chemical used in a per field chemical application plan.
Check out the quick video below for a tutorial on the sumif feature in Excel.
Also, if you’re interested in checking out a demo account of our software click the button below.
Passionate about farm finances, software, and assets that produce cash flow (oil wells/farmland/rentals). U of MN grad.
Excel For Farmers: Data Tables
This is the first post in a series that will focus on how Microsoft Excel tips and tricks for farmers. Spreadsheets are an awesome tool for any farm decision maker!Read More »
Excel For Farmers: VLOOKUP
In this blog post, we talk about a great piece of Excel functionality: the VLOOKUP formula. It's an awesome function for conducting price comparisons on farm input expenses.Read More »
Excel For Farmers: Absolute Cell Referencing
In this post we discuss one of the building blocks of spreadsheets, the ability to copy and paste formulas that reference certain pieces of data. It's a very helpful feature when build farm-focused spreadsheets and calculators.Read More »