Sumproduct formula
Hi Experts,
I would like to request Experts help create a Sumproduct formula for "Table1" and Table2" at "Report" sheet based on data at "Data" sheet.
Table1: need to count how many time the same date are appeared at Column E (Data_sheet) according to month.
Table2: 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.
CountData.xls
I would like to request Experts help create a Sumproduct formula for "Table1" and Table2" at "Report" sheet based on data at "Data" sheet.
Table1: need to count how many time the same date are appeared at Column E (Data_sheet) according to month.
Table2: 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.
CountData.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,
Thanks a lot for the formulas.
Thanks a lot for the formulas.
ASKER
Thanks for the formula.