Forum Discussion
Using Excel to create count number report
I use Excel 2007 on Windows 10. I have a database of employee pay for 12 months. I am trying to produce a report showing how many employees were paid each month.
Glad I could help
I ran into a glitch while trying to re-create your solution to the count problem with the Pivot table. How you linked the sum of values to the Names, and how you created the months of the year. Everything I did mirrored your output.
Well, I'm not a big fan of auxiliar columns nor complex matrices formulas because with a huge dataset it jeopardises the performance.
Anyway, find attached 2 possible solutions you can try them.
{=SUM(IF((MONTH(DateColumn)=MonthID)*MATCH(MONTH(DateColumn)&EmployeeColumn;MONTH(DateColumn)&EmployeeColumn;0)=MATCH(ROW(EmployeeColumn);ROW(EmployeeColumn));1;0))}- I still couldn't make out how the "month" column came in place. It is not in the data sheet.
There is no column named as MONTH.
There is a report where you can see month by month the result of the payments (quantity and summation)
When we put a date on a column we can manage it with some different date formulas such as Month(Date).
Have a look, I posted a file with the same data provided by you.
