Forum Discussion
Formula Help Needed to find Distinct Client Interactions
Hi! I'm using Microsoft Excel 2016 on a PC. I am creating a report that lists the number of specific types of interactions with clients by Team during a chosen time frame. I have been able to a...
Hi RobDevens,
if your COUNTIFS formula generally works ok, then you can try it like this for a distinct count:
{=SUM(1/COUNTIFS(Data!$C:$C,Sheet1!$D$1,Data!$C:$C,Sheet1!$D$2,Data!$D:$D,Sheet1!$A6,Data!$E:$E,Sheet1!B$5))}
Please note that you have to enter it as an array formula, That means, you must not enter the curly brackets manually, but use CTRL+Shift+Enter to close the formula.
Thanks for the suggestion! When I use this, though, I don't end up with the correct result. The formula produces 0.058823529 as the value.