A good spreadsheet should play well with other spreadsheets. That means if you enter something into one spreadsheet, then you can easily refer to another spreadsheet that has additional information about that same something. Here’s an example … Say you are setting up a schedule for all the crops you are going to direct seed. … More FSA Tip #19 Refer to things with INDEX MATCH
This spreadsheet tip follows up my post about our seed room. In it I look at the basics of how we manage our seed inventory through a spreadsheet. It is easy to try to make a spreadsheet row do too much. But by breaking down one row into multiple rows, you can get more detail … More FSA Tip #6 Every Row Tells A Story
SUMIF let’s you SUM up certain cells IF they meet certain conditions. … More FSA Tip #4 Sumif and Sumifs!