How To Become Morgue Diener

add criteria between dates

Write INTI ALONSO from Mar del Plata.

Hi how you wanted to know if you can help me with this: I have 365 sheets (all on the same sheet, one above the other) that represent the daily box, where outgoing packages, the incoming stock , the amount of sales per item and total (only 20 products), how I can make an equal return, but where you enter from (date) until (date) and I add all the values \u200b\u200bfor the boxes of the cells that are within the range selected? For example, determine a date range and puts the number of packages sold, the total entrants, outgoing, and so all the variables of the forms of the interval, thanks for your help!

And send a screenshot of your return (click on image to enlarge):

This problem can be solved with matrix functions as SUMA.PRODUCTO or SUMAR.SI with conditional, but is complicated by having to extract data in a range of dates.

The easiest way to solve it is using autofilter and subtotals . Of course, this solution is to resign aesthetic pretensions.

cut The data autofilter and subtotals function finishes the job by adding only the selected data. Does not work with a very common, it is necessary to build the = SUBTOTAL (9, $ A $ 3: $ A $ 14, C3: C14)

For example, to know the total incoming of all articles between 3 and January 5 , choose incoming in autofilter column type:


Y then the range of dates, choosing "custom" in the date column autofilter:


And here the final result:

explanations seem more difficult than it really is.

To obtain the existence of each item: = C3 + C4-C5 (with cells corresponding to each product), what I have in stock, plus what comes in the day, less than what I sold. Karen