I chose SUMPRODUCT for the first video because it was the first formula that blew my mind.
I had been doing all kinds of spreadsheet acrobatics to turn our weekly harvest projections into sales projections. Though they worked, they were bulky formulas that left room for errors to creep in.
Then I discovered SUMPRODUCT.
One simple formula cured one huge headache.
In this video, I illustrate how you can use SUMPRODUCT to easily calculate the value of a CSA vegetable basket or projected sales at a farmers market.
You can download the sample spreadsheets if you want to follow along at home!
I'd love to hear whether you're already using SUMPRODUCT or if it's a new tool for your spreadsheets!
What spreadsheet tips would you love to see?
Every week I send out a newsletter with a farmer spreadsheet tip about spreadsheet formulas or tools for you farm.
I also write about seeds and all kinds of other farming topics!