Excel For Farmers: The Sumif Formula

Nick Horob

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.

Click here for a demo
Nick Horob

Nick Horob

Passionate about farm finances, software, and assets that produce cash flow (oil wells/farmland/rentals). U of MN grad.

Fargo, ND
Related Posts
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 »