Modify a COUNT(DISTINCT(COLLECT to a COUNTIF(DISTINCT(COLLECT

tgattsh

So I have this formula which works fine.

=COUNT(DISTINCT(COLLECT({FPR24-INSTALLER}, {FPR24-INSTALL DT}, =Date@row, {FPR24-INSTALL DT}, =(Date@row))))

I want to change it to a COUNTIF but I can't get it to work.

=COUNTIF(DISTINCT(COLLECT({FPR24-INSTALLER}, {FPR24-INSTALL DT}, =Date@row, {FPR24-INSTALL DT}, =Date@row)), {FPR24-Res/Com}, "Res")

It's probably something simple, but I can't figure it out. Any help would be appreciated. Thank you...

Paul Newcome

You wouldn't use a COUNTIF. You would just stick with the COUNT and include the additional range/criteria sets in the COLLECT function.

Paul Newcome

You wouldn't use a COUNTIF. You would just stick with the COUNT and include the additional range/criteria sets in the COLLECT function.

tgattsh

@Paul Newcome Thanks Paul, that worked just fine. Just over thinking it I guess...

Paul Newcome

Happy to help. 👍️