Farm spreadsheet. Struggling with a formula. Any help would be appreciated.
I have a sheet that lists daily livestock nutrition needs with start and end dates. The list is long and has overlapping ranges. On another sheet I would like to summarize the quantity of nutrition needed for a given period, for example monthly.
The formula I need would be on the second sheet and would multiply the number of days of each row on the first sheet that occur in the specified date range, with the quantity of nutrition needed and then sum all of those quantities together.
I simplified the sheets to show an example.
Truly appreciative for any help. I’ve put a stupid number of hours on this and haven’t made any progress. Only solutions I’ve come up with are incredibly clunky.
I have a sheet that lists daily livestock nutrition needs with start and end dates. The list is long and has overlapping ranges. On another sheet I would like to summarize the quantity of nutrition needed for a given period, for example monthly.
The formula I need would be on the second sheet and would multiply the number of days of each row on the first sheet that occur in the specified date range, with the quantity of nutrition needed and then sum all of those quantities together.
I simplified the sheets to show an example.
Truly appreciative for any help. I’ve put a stupid number of hours on this and haven’t made any progress. Only solutions I’ve come up with are incredibly clunky.