I’ve been working on a secret project.
I call it the the Farmer Spreadsheet Academy and it just went public!
Step one of this new venture is a series of weekly farmer spreadsheet tip videos.
The first video is about the formula SUMPRODUCT.
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!
If you enjoy the video please hit the thumbs up on the youtube page.
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?
Leave you answers in the comments to this blog post or in the comments on the video’s youtube page.