Spreadsheet Spending

So we’ve got round to adding our 4th sheet to our DIY growing spreadsheet.

Spreadsheet Spending works for us for the now and as before. Shared the formula we used. Just Because…

A quick look see at our eight column headings.

Spreadsheet Spending

Select number 1 on the rows, to highlight the first row. Click on Data in the ribbon and from the drop down data menu select and click on, AutoFilter.

We want to import our random latin family names used in Column A of our Index Sheet.

Select cell A2 on our new Spreadsheet Spending sheet. Choose Data and then click on Validity from the drop down menu available.

In Criteria, change the All values, currently chosen and select Cell range.

Allow: Cell Range

Source: SeedFamily (Taken from Our Named Ranges)

Enter named range, SeedFamily into Source (from index sheet, column A).

Provided you’ve clicked OK? A drop down box with our named range appears in cell A2.

Forgot named ranges? Click on Sheet and then Named Ranges, Manage.

Import the seeds / content from our index sheet named ranges into our Seeds Name, Column B, Cell B2.

Allow: Cell Range

Source: INDIRECT(A2)

We are now able to choose content/seeds from each of our named ranges.

Random formula used for our totals of column E, Costs.

Spending Total: Column E, Cell E12 (Cell format currency)

=SUM(E2:E11)

Filter Sub Total: Column E, Cell E13 (Cell format currency)

=SUBTOTAL(9,E2:E11)

Filter % of Total: Column E, Cell E14 (Cell format percent)

=IF(E13=0,"-",(E13/E12))

Random details added just to test is all.

Filtered to Asteraceae, just to test our formula works? Job done, Move On.

Travel Safe

Inabit