I would like to request Experts help create a Sumproduct formula for "Table1" and Table2" at "Report" sheet based on data at "Data" sheet.
: need to count how many time the same date are appeared at Column E (Data_sheet) according to month.
: Count how many time the listed "Item" at Column C (Data_sheet) appeared based on Month (Column E _Data sheet)
I have manually inserted a few data at Table 1 and 2 for Experts to get better view. Hope Experts could help.