I have a product sales report sheet with these details:
- customer name in one cell B2, all sheet calculations include a condition to this cell.
- product names in column C
column D has a formula to sum all product Quantities based on the name of in column C as follow:
=SUMIFS(Quantities;Customers;$B$2;Products;C7)where the defined database ranges are columns in other sheet, I have another column with them contains Dates in the form of
YYYYMMDD HH:MM AM/PM
What I’m looking for is:
I want to add in column F a formula same as in column C but to add a condition to limit the sum between two dates, year and month, assuming:
limit from month in H2 and year in I2 to month in H3 and year in I3
Note: if this can’t be achieved because of the Dates range form, I can remove the time and change it to YYYY.MM.DD but can’t remove the day. also, I can change the sum between two dates to include the day if that’s easier to achieve.
Thank you all, I appreciate all time and effort in solving this for me.