How to count only unique values from a column in a COUNTIFS

[slam]

I have this formula so far:

=COUNTIFS(Raw!$B:$B,"11/22/2023  12:00:00 AM",Raw!S:S,A24,Raw!W:W,C23)

The problem is that my Raw worksheet has a lot of duplicates, and I only need to count one of each instance from column C on the Raw worksheet. Could someone please show me how to incorporate that into my formula?

Thanks!

 

[slam]

change .... the filter range to the column that needs to be summed.

Confused about this part. I need the Raw!$C:$C reference to identify the unique values don't I? So if I replace that with the SUM range, how does it know the unique values to SUM?

=IFERROR(SUM(UNIQUE(FILTER(Raw!$C:$C,(Raw!$B:$B="11/22/2023  12:00:00 AM")*(Raw!$S:$S="Planned")*(Raw!$X:$X,="2025")))),0)

Sorry I'm struggling, and thank you for your patience.

 

[Fluff]

As this is obviaously a completely different question it needs a new thread.
In that thread please explain clearly EXACTLY what you want, rather than making people guess.