Countif with date range/multiple criteria

[Nordicrx8]

Hey all,

I'm trying to build a new spreadsheet and I need some help to take the manual process out of the report.

Essentially I have a large report for “year to date sales”, and I need to find out how many were done, by who, per month. I also need to add up the totals of the sales for each month by employee.

Column C has the name of the employee
Column L has the date
Column K has the sale value

Currently it’s a manual process of having to change the range each month, but I’d like to automate it to reduce the work needed to update the sheet each month.

Any help on this would be GREATLY appreciated!

Thank you!

 

[MrKowz]

Try using a Pivot Table. Put the Date and Employee name as the row field, right click on a date a group>months. Put the sale value in the values field.

 

[Nordicrx8]

I want to avoid a pivot table because this is only the first step for this data. Im making "report cards" with the data for my team.