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.
There are several ways to do that
Pivot table, Formulas, Power Query, etc.
I'm attaching 2 different solutions so you can choose witch one is best for you.
Sadly, a straight pivot table doesn't answer the question. I tried that too. The original question was "how many employees were paid each month?" There were indeed 124 payments in January, but only 61 employees receiving those 124 payments.
I was stymied by this one.....still haven't figured it out.
Sheet2 in the attached shows the detail behind the Pivot Table's count for Jan.