FSA Tip #4 Sumif and Sumifs!

This morning I was getting ready to post about Farmer Spreadsheet tip #5, when I realized I never posted about #4.

I guess I got carried away by the garlic harvest, and then the garlic cleaning, and tomorrow is the Ste-Anne-de-Bellevue garlic festival!

Let’s remedy that.

Today we take Tip #4, tomorrow number FIIIIIIIIIVE!

Farmer Spreadsheet Tip #4 is about SUMIF and SUMIFS

SUMIF (and the lesser known SUMIFS) is an important formula for your spreadsheet toolbox.

SUMIF let’s you SUM up certain cells IF they meet certain conditions.

In this example I look at using SUMIF to convert a planting schedule into a seed order.

But SUMIF also open the door to some very interesting uses that we will be exploring in the future!

Are you using SUMIF regularly in your spreadsheets?


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s