Home / Tag Archives: countif

Tag Archives: countif

Lookup for Product Effort Timesheet

For this problem we received a copy of the workbook. We then used a formula to count the number of 'Product' occurences for each staff member. That count was then transferred to a staff member summary worksheet to report the total counts for all 'Products' across the team. To simplify the formula and the structure of the workbook we also recommended to record all the staff time into one worksheet for the year, rather then a separate worksheet for each month

Read More »