If you always have valid numbers in 'Number' column, then you can shorten the formula to;
F2 = Name, ie Angela![]()
=SUM(IF(FREQUENCY(IF((A$2:A$61=F2)*(B$2:B$61=G$1)*(C$2:C$61="Outbound"),D$2:D$61),D$2:D$61),1))
G1 = Month, ie August
If you always have valid numbers in 'Number' column, then you can shorten the formula to;
F2 = Name, ie Angela![]()
=SUM(IF(FREQUENCY(IF((A$2:A$61=F2)*(B$2:B$61=G$1)*(C$2:C$61="Outbound"),D$2:D$61),D$2:D$61),1))
G1 = Month, ie August
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks