Sum of data between dates
Hope someone can help me, if this is at all possible.
I have a request form that my users use to request ink and I would like to use a formula to show me how much we have used for each Ink type per month or during the last 30 days.
Below is my sheet which when a user requests ink it auto fills a request date field and puts a 1 into a column for the ink requested (will only ever one be a 1)
I have managed to make a sheet showing the overall total of requests for each ink type and a separate formula showing the number of all requests made between certain dates but not a formula to show me both (for example how many 87A cartridges were ordered in the last 30 days).
Is it possible?
Help Article Resources
Check out the Formula Handbook template!