How to Sum the Frequency of column dependent on another column.

dharv3y78

New Member
Joined
Oct 26, 2019
Messages
3
Office Version
365
Platform
MacOS
Hi,

I am trying to solve a problem I am have trying to add the days of shifts for multiple people but running into a issue it will correctly workout the number of shifts excluding dates that are the same but I need it read a repeating date if that person name is different.

I have all this information in a table with a slicer to choose the person and then a second slicer for a number against that person, there could be multiple numbers against the person, so I need the cell F9 to read the Person Name, Number, and Date of Shift and come back with a total days worked even if there is repeating dates for other persons.

This is the code I'm currently using
HTML:
=SUM(IF(FREQUENCY(MonthlyExpenses16[Date of Shift],MonthlyExpenses16[Date of Shift])>0,1))
Please see attached Image


Thanks
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

dharv3y78

New Member
Joined
Oct 26, 2019
Messages
3
Office Version
365
Platform
MacOS
Sorry Image didn't post so hopefully it does now.



Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,099,331
Messages
5,467,984
Members
406,562
Latest member
tobruk

This Week's Hot Topics

Top